Find Most Blocked Queries in sql

on

Find Most Blocked Queries

Posted by 
on  May 31 2009
SELECT
    OBJECT_NAME(objectid)
    ,BlockTime = total_elapsed_time - total_worker_time
    ,execution_count
    ,total_logical_reads
FROM sys.dm_exec_query_stats qs
cross apply sys.dm_exec_sql_text(qs.sql_handle)
ORDER BY total_elapsed_time - total_worker_time DESC

Comments

Post a Comment