An XEvent a Day (21 of 31) – The Future – Tracking Blocking in Denali
- by Jonathan Kehayias
One of my favorite features that was added to SQL Server 2005 has been the Blocked Process Report trace event which collects an XML report whenever a process is blocked inside of the database engine longer than the user configurable threshold. I wrote an article about this feature on SQL Server Central two years ago titled Using the Blocked Process Report in SQL Server 2005/2008 . One of the aspects of this feature is that it requires that you either have a SQL Trace running that...(read more)