How to monitor blocking in SQL Server 2005 and in SQL Server 2000 (Knowledgebase Article)
In Microsoft SQL Server 2005, you can also use the Blocked Process Report event class in SQL Server Profiler to capture the information about a task that has been blocked for more than a specified amount of time.
For more information about the Blocked Process Report event class, visit the following Microsoft Developer Network (MSDN) Web site:
http://msdn2.microsoft.com/en-us/library/ms191168.aspx
No comments:
Post a Comment