[MSSQL] CPU 점유율 확인 쿼리
USE master;SELECT TOP 10 REPLACE(CONVERT(VARCHAR(20), CONVERT(MONEY,qs.total_worker_time / qs.execution_count/1000),1),'.00','') as [Avg CPU Time(ms)] ,qs.execution_count ,substring (qt.text, qs.statement_start_offset/2+1, (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) as query_text ,qt.dbid..
더보기