We’re moving to queues

Some time ago I asked on GitHub whether we should move to using SQL Server Service Broker rather than SQL Agent jobs. Sadly, there have been zero responses from the community, so I made my own decision. You can guess what the decision was. What is Service Broker SQL...

What’s new in version 3

Version 3 of SQLWATCH brings several, long-awaited features that should make your SQL Server monitoring easier and better. Grafana Dashboard The history of SQLWATCH goes back to around 2010, when it was just a bunch of scripts and agent jobs for ad-hoc performance...

SQLWATCH 2.5 is now available

Fixed an issue where table utilisation was not being collected for databases other than SQLWATCH. As all tables are being processed now, the execution time for [dbo].[usp_sqlwatch_logger_disk_utilisation_table] may increase considerably. Please test it in...

Report parameters, time slice and intervals

Report Start and End time When retrieving performance data from SQLWATCH database we have to keep in mind the fact that this is a decentralised architecture meaning the performance is not being offloaded to a dedicated central repository but is hosted on the monitored...
Don’t miss the DataWeekender virtual Conference

Don’t miss the DataWeekender virtual Conference

A bunch of fantastic Data Community members have organised a free, virtual Data Community conference. 6 tracks and 42 sessions presented by some of the best speakers in the industry. Next Saturday, May 2nd, 2020 – join and learn about SQL Server 2019 Big Data...

SQLWATCH 2.3 is now available

Version 2.3 brings a number of bug fixes and improvements: [Bugfix] Fixed an issue where agent jobs would not be alerted on in different time zones.[Bugfix] Fixed a PK violation for tables with compressed and uncompressed indexes (i.e. column store and row...