Monitor and learn SQL Server for free.

Troubleshoot issues at every step of your DevOps pipeline and catch problems before they reach the production environment.

Because every environment is a production environment for someone.

SQLWATCH is an Open Source and completely free SQL Server Monitoring project. The aim is to provide a comprehensive monitoring solution for everyone and for every environment as well as educate about SQL Server management and performance. SQLWATCH is often being used to replace expensive enterprise monitoring or simply to fill the gap and monitor non-production environments such as DEV, TEST, Quality Assurance (QA), to support you and your application from development to production. It can be integrated with DevOps pipelines to consider performance metrics as part of Operational Acceptance Testing (OAT) and User Acceptance Testing (UAT) sign-offs.

Features

  • 5 second (configurable) granularity to capture important spikes in your workload.
  • Grafana for real-time dashboarding and Power BI for in depth analysis
  • Minimal performance impact (around 1% on a single core SQL Instance when using broker for invocation).
  • Out of the box collection with minimal configuration required to get it up and running.
  • Extensive configuration available to make it fit into your workload.
  • Zero maintenance. It has been designed to maintain itself.
  • Unlimited scalability. As each instance monitors itself, you are not constraint by the capacity of the monitoring server.
  • Works with all supported SQL Servers (with some limitations on 2008R2)
  • Alerts and integrations (Email, HTTP REST, exec execution based on T-SQL conditions)

Power BI and Grafana Dashboards

  • SQLWATCH WhoIsActive
  • SQLWATCH_index_stats_beta4
  • SQLWATCH wait stats beta 4
  • SQLWATCH Q&A
  • SQLWATCH Blockers

Screenshots may represent an earlier release that may differ slightly from the latest release.

Join the community

SQLWATCH is 100% free and Open Source. You can get a source code or a compiled release from GitHub.

GitHub stars GitHub forks GitHub downloads

Join our forum to discuss features, issues, get and give help and meet other SQLWATCHers!

Have a burning issue? Join the live conversation and ask for help from other SQLWATCH users on a live chat.

Latest Blog Posts

Want to learn about Microsoft Data Platform?

Check out community events. Provided by Data Community Events:

Next Upcoming Event
19 October 2021
  • 00

    days

  • 00

    hours

  • 00

    minutes

  • 00

    seconds

Enter your email address to subscribe to this blog and receive notifications of new posts by email. No spam, promise, and you can unsubscribe anytime. Alternatively, you can subscribe via RSS