Hey SQLWatchers, First of all, thank you for the growing community and for using SQLWATCH. SQLWATCH has reached over 10000 downloads. This does not include source code downloads and offline installations. I am myself aware of many places that download the release or source code once and deploy to their [...]
In the previous post, I have explained how to configure SQLWATCH To send simple, plain text notifications to Microsoft Teams. https://sqlwatch.io/blog/articles/how-to-send-notification-to-microsoft-teams/ Today, we are going to look at how to send formatted cards: Microsoft Teams Cards Action templates Formatted cards require slightly more complex JSON structure and for that reason, [...]
Some time ago we discussed how to send notifications to Microsoft Teams: https://sqlwatch.io/blog/articles/how-to-send-notification-to-microsoft-teams/ In this post, we are going to look at doing the same with Slack. The only difference between these two platforms is in the payload they expect. Beyond configuration of the correct action, the action association process [...]
I am happy to announce that thanks to our fantastic SQL Server Community it is now possible to deploy SQLWATCH using dbatools. If you work with SQL Server and are not familiar with dbatools you should check it out now, it will change your DBA life forever. With dbatools we can [...]
I have been meaning to write how to integrate SQLWATCH with different platforms for a long time. Recently a very kind person bought me a coffee and said they have implemented Microsoft Teams integration which motivated me to finalise it. Hi Marcin, love your work, just startet to rollout the [...]
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 [...]
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 [...]
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 [...]
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 [...]
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.
