Welcome to Aussie SQL Server Bloggers Sign in | Join | Help

SQL Profiler - Errors & Warnings: Blocked Process Report

Now, here's a cool new SQL 2005 Profiler event I used for the first time in anger yesterday. What I love about this event is that it actually spits out significant & useful data from both the blocked process & blocking process - locked resource, input buffer, time, spid etc into a single (xml) report. Very handy for digging into query timeout / blocking issues indeed.
Published Wednesday, 15 March 2006 7:39 AM by Greg_Linwood
Filed Under:

Comments

No Comments
Anonymous comments are disabled