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

How to check locks on the database? Expand / Collapse
Author
Message
Posted Tuesday, March 24, 2009 2:28 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 11:58 AM
Points: 1,279, Visits: 1,886
My web sides are going down, I want to check if there is any locks on my database, what is the command or procedure for that. Thank you
Post #682829
Posted Tuesday, March 24, 2009 11:41 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, December 8, 2014 6:26 PM
Points: 942, Visits: 1,069
If you are having timeout because of blocking you can use the sp_blocker_pss80 (http://support.microsoft.com/kb/271509) here to try to find out what is causing the issue.

Be warned this produces a lot output ... Thanks.

Mohit.


---

Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.


How to ask for help .. Read Best Practices here.
Post #683050
Posted Wednesday, March 25, 2009 3:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 7:32 PM
Points: 700, Visits: 1,029
I'd suggest sp_lock to get a list of locks. You might also want to read up about locking types.

For blocking processes, sp_who & sp_who2 will give you a good idea of what is happening on your server. To look at processes in further detail, try
dbcc_inputbuffer(spid)
Post #683130
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse