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

Yes and KBA fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ 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.