SQL Server alerts Archives

SQL Server Configure alerts for long running queries

July 10, 2013December 23, 2019 - by SQL Geek - 18 Comments.

Recently, I came across a situation where on one of the server I manage, there was a full text query which took hours to complete and many times caused overall system …

SQL Server Real-time Monitoring using WMI classes: Part -3

March 9, 2012November 28, 2014 - by Abhay Chaudhary - Leave a Comment

SQL Server Real-time Monitoring using WMI classes: Part -3 I hope you have been through both Part 1 and Part 2 of this series .In Part 1 we discussed about using …

SQL Server Real-time Monitoring using WMI classes: Part -1

February 18, 2012September 19, 2014 - by Abhay Chaudhary - 28 Comments.

SQL Server Real-time Monitoring using WMI classes: Part -1 We all know that that SQL Server had a great face lift from SQL Server 2000 to 2005 .Everything else was a …