InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 16:14:15 GMT20http://www.sqlservercentral.com/Forums/Topic140349-186-1.aspxWe 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.Fri, 28 Oct 2005 16:18:00 GMTJohn Scarboroughhttp://www.sqlservercentral.com/Forums/Topic140349-186-1.aspxaba_lockinfo does a good job for this. Every 5 seconds is the best way as it was said aboveThu, 28 Oct 2004 01:03:00 GMTAndriy Lishchynskyyhttp://www.sqlservercentral.com/Forums/Topic140349-186-1.aspxwell 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.Thu, 07 Oct 2004 03:37:00 GMTcolin.Leversuch-Robertshttp://www.sqlservercentral.com/Forums/Topic140349-186-1.aspxComments posted to this topic are about the content posted at <A HREF=http://www.sqlservercentral.com/columnists/eleiba/identifyingblockinglocks.asp>http://www.sqlservercentral.com/columnists/eleiba/iWed, 06 Oct 2004 11:24:00 GMTEli Leiba