MSSQL
-
MSSQL CPU 사용률 높은 쿼리 찾아내는 쿼리컴퓨터&모바일/MSSQL 2019. 8. 1. 10:06
SELECT TOP 50 qs.creation_time, qs.execution_count, qs.total_worker_time astotal_cpu_time, qs.max_worker_time as max_cpu_time, qs.total_elapsed_time,qs.max_elapsed_time, qs.total_logical_reads, qs.max_logical_reads, qs.total_physical_reads, qs.max_physical_reads, t.[text], qp.query_plan, t.dbid, t.objectid, t.encrypted, qs.plan_handle, qs.plan_generation_num FROM sys.dm_exec_query_stats qs CROSS..