Three different ways to find blocking in SQL



SP_WHO2
It shows blocking by the presence of blkby column value.
Sysprocesses
select * from master..sysprocesses where blocked >0
Activity Monitor
Open Activity Monitor at any time by pressing CTRL+ALT A.

Comments

Popular posts from this blog

SQL Server:Steps to Configure Database Mirroring by T-SQL Script.

SSIS2008R2 Error: 0xC0209303 at Package: