September 9, 2010  
  Register Login 
BLOGS
There are no categories in this blog.

SEARCH BLOG

BLOG ARCHIVE
Archive
<September 2010>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Monthly
October, 2008
  SQL Server Blogs     



Your Ad Here

 

sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

Create a new trace in Profiler and select the "Blocked Process Report" event listeds under the "Errors and Warnings" event category.

After this setup, you should see all blockings taking longer than 10 seconds using this trace.

Permalink |  Trackback
Location: BlogsAleksandar Tosic's Blog    
Posted by: Aleksandar Tosic Wednesday, October 15, 2008

Your name:
Title:
Comment:
Add Comment   Cancel 
Copyright 2007 by www.dballinks.com Terms Of Use Privacy Statement