Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Identifying Blocking Locks Expand / Collapse
Author
Message
Posted Wednesday, October 6, 2004 11:24 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, February 17, 2014 2:05 AM
Points: 47, Visits: 18
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/eleiba/i
Post #140349
Posted Thursday, October 7, 2004 3:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
well I don't wish to appear negative but checking for a lock that has been held for 5 to 10 mins might not be very efficient. I do a similar check periodically on our oltp systems but I check every 5 seconds for blocking locks.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #140495
Posted Thursday, October 28, 2004 1:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 26, 2005 6:59 AM
Points: 2, Visits: 1
aba_lockinfo does a good job for this. Every 5 seconds is the best way as it was said above
Post #143802
Posted Friday, October 28, 2005 4:18 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 24, 2014 1:52 PM
Points: 290, Visits: 52
We have servers that check every 30 seconds, and alerts us to blocking chains. However, our worst blockers are 3rd party apps that just block sometimes, nothing can be done, and the rocket scientist who purchased the app is long gone. We definitely don't want to be notified every 30 seconds! Our blocking notification process differs somewhat from what is in this article, but is pretty typical stuff that can be found on the web.

John Scarborough
MCDBA, MCSA
Post #233586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse