sysprocess "BLOCKED" | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sysprocess "BLOCKED"

Hi All, I have been looking at sysprocesses system table for monitring blocks if any on database
and got some ideas which I wanted to share which U all are aware so just wanted confirmation and your ideas. 1> The BLOCKED columns default value is 0
2> If there is a process blocking it would show SPID of process hindering it.
3> So to check if there are blocks you just need to run
select * from sysprocesses where blocked > 0
Cheers,
Satish

Yes and KBAhttp://support.microsoft.com/kb/906344 fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>