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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 21, 2014 3:20 AM
Points: 432, Visits: 1,073

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: Saturday, November 22, 2014 6:10 PM
Points: 293, Visits: 821
http://support.microsoft.com/kb/224453
Post #774653
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse