Top SQL Queries for CPU Time

  • 13 September 2022
  • Sean Huggans

Displays the top X running SQL Queries for CPU TIme.

Query: 
SELECT TOP 50
ObjectName = OBJECT_SCHEMA_NAME(qt.objectid,dbid) + '.' + OBJECT_NAME(qt.objectid, qt.dbid),
TextData = qt.text,
DiskReads = qs.total_physical_reads,
MemoryReads = qs.total_logical_reads,
Executions = qs.execution_count,
TotalCPUTime = qs.total_worker_time,
AverageCPUTime = qs.total_worker_time/qs.execution_count,
DiskWaitAndCPUTime = qs.total_elapsed_time,
MemoryWrites = qs.max_logical_writes,
DateCached = qs.creation_time,
DatabaseName = DB_Name(qt.dbid),
LastExecutionTime = qs.last_execution_time
FROM sys.dm_exec_query_stats AS qs CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt 
ORDER BY qs.total_worker_time DESC  
Query Type: 
SQL Query