Search

Tuesday, June 12, 2012

Different ways to find out the Blockings

There are number of ways to find out the details of the system processes IDs (spids) involved in blocking.

  • sp_who2 System Stored Procedure

  • sys.dm_exec_requests DMV

  • Sys.dm_os_waiting_tasks

  • SQL Server Management Studio Activity Monitor

  • SQL Server Management Studio Reports

  • SQL Server Profiler

    • Posted by at

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)