Community driven SQL Server Performance Monitor

Completely free and Open Source, developed by SQL Server DBAs...

...because we have all been there, blindly trying to figure out why things aren't as fast as they used to be.

 

Demo We are on GitHub

Latest version: SQLWATCH-v1.3.20

 

SQL Server Activity and Key Performance Metrics

SQLWATCH is collecting a number of key metrics from Dyamic Management Views, Performance Counters, WMI, XE Sessions, SQL Waits and Storage Statistics to draw a comprehensive activity report of a SQL Server instance over time.

It provides index advisory based on the actual index usage as well as missing indexes.

It also collects database growth and disk utilisation to help plan for storage space.

With most enterprise monitoring solution being licensed per instance, you probably never monitor performance in PRE, QA or DEV enviroments. Now you can.

 

Simple yet effective concept

No complex monitoring infrastructure required.

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

Designed with small disk footprint in mind. Different retention periods for different data loggers to maintain low disk utilisation.

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.

It gives you the full control when data collection runs, you can amend schedules and disable jobs you do not wish to run or run them on demand.

 

Open Source Visual Studio Project

No hidden "features"

No complex code, all written in nice and tidy T-SQL with a bit of PowerShell

No complex routines, no custom error handlers and confusing logs. Thanks to the use of SQL Agent all execution failures go to the Job output and are visible in the standard Job History window.

What you see is you what you get and you are more than welcome to contribute or suggest new features.

 

 

Key collectors

 

 

Performance

Performance counters, database and storage performance, query analysis and workload statistics

Data Growth

Database space analysis, storage overview, database and disk growth.

Index Advisor

Index overview and index strategy advisor, individual index analysis, missing index report

 

 

Performance Dashboard Demo

 

 

 

 

Latest Updates

 

 

Latest blog post

Report parameters, time slice and intervals

When retrieving performance data from SQLWATCH database we have to keep in mind the fact that this is a decentralised architecture meaning, we are connecting to possible a production instance and there could be gigabytes of performance data in the SQLWATCH database. For obvious reasons we do not want to pull all the available data into PowerBI as this could impact the service. In this post we are explaining the design behind time parameters. …read more

Posted in Blog | Leave a comment

Read more on our Blog...

Latest release

SQLWATCH-v1.3.20

  • [fixed] issue #47

  • [added] interrogate system_health extended event session to get information about long waits including query text, workers and long io requests.
  • [added] new snapshot (6) for query text with default 3-day retention
  • [added] new performance dashboard with lots of new tabs: Query statistics, memory, database performance, logical file performance, logical disk performance and generic performance counter analyser

  • [removed] dacpac from branches. these are binary files causing merge problems. dacpacs are now available in releases.

See changelog...

Our mission

The aim of this this project is to provide a free, repository backed, SQL Server Monitoring. As DBAs we need to know what happened in the database in a given point in time in order to troubleshoot performance or configuration problems. Unfortunately this is not an easy task and hence there is not a lot of free monitoring solutions available. SQL Server is very popular and used by a lot of people but not every one can afford expensive, enterprise monitoring solution. We are here to fill this gap!

Why we do it

Because we know how important it is to know how systems behave over a period of time rather than just when the problems happen. 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.