Syntax
sp_blocked_process_report_viewer [@Trace = ] 'TraceFileOrTable' [ , [ @Type = ] 'TraceType' ]
Arguments
[@Trace = ] ‘TraceFileOrTable’
Is the name of the trace table or trace file that holds the blocked process reports
[@Trace = ] ‘TraceType’
Is the type of file referenced by TraceFileOrTable. Values can be TABLE, FILE or XMLFILE. The default is FILE
Remember: When it comes to concurrency problems, you don’t have to guess what’s wrong!!!
I explain when to use this tool flowchart style!
<map id="mymap" name="mymap"> <area title="Wait Statistics" shape="rect" coords="309,97,450,142" href="http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx" alt="Wait Statistics" target="_blank" /> <area title="Who
Is Active" shape="rect" coords="309,176,450,218" href="http://sqlblog.com/blogs/adam_machanic/archive/2011/04/23/leader-of-the-block-a-month-of-activity-monitoring-part-23-of-30.aspx" alt="Who Is Active" target="_blank" /> <area title="SQL Trace" shape="rect"
coords="314,240,442,266" href="http://msdn.microsoft.com/en-us/library/ms191168.aspx" alt="SQL Trace" target="_blank" /> <area title="SQL Server Blocked Process Report Viewer" shape="rect" coords="325,293,435,417" href="http://sqlblockedprocesses.codeplex.com/"
alt="SQL Server Blocked Process Report Viewer" target="_blank" /> <area title="Event Notifications" shape="rect" coords="310,435,448,491" href="http://msdn.microsoft.com/en-us/library/ms182602.aspx" alt="Event Notifications" target="_blank" /> <area title="The
Future – Tracking Blocking in Denali" shape="rect" coords="308,520,450,559" href="http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/12/21/an-xevent-a-day-21-of-31-the-future-tracking-blocking-in-denali.aspx" alt="The Future – Tracking Blocking
in Denali" target="_blank" /> </map>