[개발] DataBase Tool SAP/1. MS_SQL
[MS-SQL] CPU 과부화 쿼리 확인
Kim Teasung
2021. 3. 2. 13:26
728x90
Select top 20
[사용 된 평균 CPU] = total_worker_time / qs.execution_count
, [사용 된 총 CPU] = total_worker_time
, [실행 횟수] = qs.execution_count
, [개별 쿼리] = SUBSTRING (qt.text, qs.statement_start_offset / 2,
(CASE WHEN qs.statement_end_offset = -1
THEN LEN (CONVERT (NVARCHAR (MAX), qt.text)) * 2
ELSE qs.statement_end_offset END-
qs.statement_start_offset) / 2)
, [상위 쿼리] = qt.text
, DatabaseName = DB_NAME (qt.dbid)
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text (qs.sql_handle) as qt
ORDER BY [사용 된 총 CPU] DESC, [사용 된 평균 CPU] DESC;
반응형