Marios Philippopoulos did a great job with an article on monitoring long-running SQL blocks with SCOM 2007 at SQLServerCentral.com. The article: Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts (http://www.sqlservercentral.com/articles/Blocking/64038/) provides a set of scripts for detecting (and display vital information about) long-running blocks in SQL Server 2000 and 2005 as well as [...]
Filed under: SCOM, SQL Server, System Center Operations Manager | Leave a Comment »
