Tuesday, May 29, 2012

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.

No comments:

Post a Comment

MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables

  Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...