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.

 

DemoGet started

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

 

SQL Server Activity and Key Performance Metrics

SQLWATCH is collecting a number of key metrics from Dynamic 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.

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

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 environments. 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

SQLWATCH 2.0 beta 5

A number of fixes in beta 5, mainly addressed extended events collectors that resulted in no data being shown on the dashboard. fixed Better handling of different collations in job deployment mechanism fixed Address INT2 wait_stats overflow on busy systems. On busy systems the correlation sequence is over smallint allocation (32k). fixed Added missing XES …read more

Posted in Blog | 11 Comments

Read more on our Blog...

Latest release

SQLWATCH-v1.3.3

  • Performance tweaks in [dbo].[ufn_time_intervals]

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.