by Marcin Gminski | Apr 9, 2021
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...
by Marcin Gminski | Apr 2, 2021
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...
by Marcin Gminski | Jun 10, 2020
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...
by Marcin Gminski | May 25, 2020
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...
by Marcin Gminski | Apr 27, 2020
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...
by Marcin Gminski | Apr 15, 2020
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...
