Tuesday, October 5, 2010

How to find bloked process in SQL Server 2005/2008

SQL Server 2005 or 2008 provides several ways to find which sessions are currently working and which session is bleked some table.

SP_WHO, SP_WHO2 are two commands to finding out who are blocked.

Example: Open Sql Server 2005 or 2008 management Studio. Then type Sp_Who it dispalys like...

51 0 sleeping                       NT AUTHORITY\SYSTEM PRAKRIT25                                                                                                                        0     msdb AWAITING COMMAND 0

 0 indicates bloked status...

Same like who we have another option called Sp_who2

No comments:

Post a Comment