Want to learn about SQLWATCH?
Join me online at Data York where I will explain what SQLWATCH is, how to install it, and how to use it. Here's the link to the event: Introduction to SQLWATCH with Marcin Gminski, Thu, Apr 6, 2023, 7:00 PM | Meetup
SQLWATCH 4.4
Contributors @OliverUweHahn, @ben-thul, @kekcjkee, @marcingminski and @pluim003 Changes Fix #410 (#411 by @kekcjkee) Bug Fixes Fix 417 (#456 by @marcingminski)fix #417 (#454 by @marcingminski)#403 - Performance Patch (#450 by @OliverUweHahn)Fix #437 (#440 by @pluim003) Maintenance Update build to include dashboard files (#453 by @marcingminski)Version bump to 4.4 (#452 by @marcingminski)Fixed minor typo, formatting change in README.md (#447 by @ben-thul)Minor grammar change (#446 by @ben-thul)Remove old PBI dashboard (#405 by @marcingminski) https://github.com/marcingminski/sqlwatch/releases/tag/4.4
Happy New Year!
Happy New Year SQLWATCHers, thank you for your support so far. I am looking forward to 2022 with new ideas and plans for SQLWATCH. Stay tuned.
I am a Microsoft MVP!
I am pleased to announce that I have been awarded the Microsoft MVP (Most Valuable Professional) award in the Data Platform category for the year 2022. I was not expecting it at all so I have not had a blog post ready for when I get it. This is just [...]
I am expanding this blog
Those who closely follow this blog and myself will know that SQLWATCH and thus this blog were an offshoot of my original blog, firstly at https://marcingminski.com and then https://marcin.gminski.net. It all started with this post https://marcin.gminski.net/blog/sql-server-performance-dashboard-using-powerbi/ and this is how SQLWATCH was born and how I ended up with essentiall [...]
Recent Test Posts
Apologies if you have received an email with random test content. I wanted to try a new template for the website and blog and somehow it decided that it will be a good idea to auto-post and thus trigger an email with some demo-content. #NeverTestInProduction
Version 4.1 is now available
Contributors @marcingminski and @tarmstrong24 Features Change to parse job name and replace binary value with Job Name (#313 by @marcingminski)Added default ERRORLOG keywords that are worth monitoring. (#319 by @marcingminski)Improvements to the test suite (#323 by @marcingminski)Tweaks to the test suite (#330 by @marcingminski)Feature tests (#317 by @marcingminski)Feature tests (#316 by @marcingminski)Added separate database for automated tests (#321 by @marcingminski)Add instance name to the Test Suite [...]
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 Server [...]
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 data collection. Once collected, it would then [...]
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 your environment first. In case you have missed 2.4 update, there have been a lot of changes: Many [...]