SQL Server Performance Monitoring framework

Free and Open Source, developed by SQL Server DBAs.

Because every environemnt is a production environemnt for someone.

 

DemoGet started

Quick installation using dbatools:

Install-DbaSqlWatch -SqlInstance YourSqlServer 

GitHub release Build Status GitHub Release Date GitHub All Releases GitHub Last Commit

 

Performance Dashboard Demo

Check out a working demo of the Power BI Dashbaord. This example runs in the Power BI Servie and it will look and work exactly the same in the free Power BI Desktop. Best experienced in Full Screen.

 

 

Features

 

 

Flexible with Zero maintenance

SQLWATCH was built to help you monitor all your enviroments, not to become another thing to worry about. It has been designed with set and fortget approach.

Written in T-SQL, no additional hardware or VM provisioning required. You can tweak and adjust as you wish.

Schema optimised for long term storage means minimal growth and ability to compare months or even years of performance statistics.

Provides insight into index usage, missing indexes, database growth and disk utilisation.

Default installation will collect most critical metrics and if this is not good enough it is super easy to enable new metrics or even add your own.

 

 

Decentralised monitoring

No complex infrastructure provisioning required.

No additional monitoring services or central servers to worry about, no additional VMs to be provisioned, no agents to install.

Optional central repository database for central reporting.

Each server monitors itself. SQLWATCH uses SQL Agent jobs for data collection which is then stored locally and not affected by network blips. This approach allows it to work in isolated networks yet it still allows for central reporting but with the benefit of distributed storage and monitoring.

Perfect for consultants that do not have 24/7 access to the client network. You can collect data from remote instances into central repository every few minutes or every few days. It's up to you.

 

 

Alerts, Reports and Integrations

Fully customisable and flexible alerting engine with actions executed via PowerShell allows almost unlimited integrations including HTTP calls, launching programs and executing T-SQL queries.

Text based alerts delivered via email, Pushover, Slack or any other service that accepts HTTP calls.

More sophisticated notifications using html reports.

Saving files to shared drives or creating "trigger" files to integrate with other systems.

Pushing data to monitoring platforms such as Zabbix and Nagios and log collectors such as GrayLog and Splunk

 

 

How it works

 

 

1. Collect

Collects pre-defined, high-granularity performance metrics.

2. Store

Stores collected data in a local schema optimised for performance.

3. Check

Check engine ensures all metrics are within the thresholds.

 

4. Action

Raises alerts or triggers actions for failed checks and metrics that breach the set thresholds.

5. Analyse & Report

Analayse Performance data using provided PowerBI Dashboard or get emails with schedueld reports.

6. Archive

Aggregates high granularity data and archives for long term storage and long term analysis.

 

 

 

 

Our mission

The aim of this this project is to provide a free, repository backed, SQL Server Monitoring for everyone. Using Power BI Q&A capabilities, we want to change the way performance monitoring is done and given an actual advice rather than just cold raw numbers. SQL Server is very popular and used by a lot of companies and people but not every one can afford expensive, enterprise monitoring solution. We are here to fill this gap!

Why we do it

Constantly growing volumes mean that it is more critical than ever to be able to performance baseline your environemnts, all of them, not just production. Repository backed monitoring gives you the benefit of being able to review historical behaviour.

Meet the team

Why not meet The Team and talk to us on #sqlwatch channel on sqlcommunity.slack.com or take a look at our Roadmap, or follow @sqlwatch on Twitter.

This site, like most websites, uses cookies. By continuing to use this website, you agree to their use.