I recently came across a tweet by Brent Ozar who touched on a very important aspect of performance monitoring. A subject that is not always well understood and can lead to misleading results. The impact of aggregation on granularity and thus observability. Brent's tweet inspired me to try and explain [...]
The observer effect is a term used in physics and it means that observing a phenomenon changes that phenomenon. Therefore, an object that is being observed, is looking different to the same, not observed object. How is this possible? In physics, this is to do with photons and electrons. An [...]
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 [...]
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 [...]
