|
1 2 3 4 5 6 7 8 |
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 |
Views – 1986