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

blocking check instance xxxxx Expand / Collapse
Author
Message
Posted Thursday, August 20, 2009 3:00 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, May 16, 2013 12:43 AM
Points: 378, Visits: 897

wt is the meaning of this.

blocking check instance xxxxx


spid waittime hostname username blockedby
dbname
----- -------- -------------------- -------------------- ----------
--------------------
179 76 master hsgsys yuyutu 121


how to check these blocking calls.
Post #774611
Posted Thursday, August 20, 2009 4:06 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 8:12 AM
Points: 275, Visits: 679
http://support.microsoft.com/kb/224453
Post #774653
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse