MSSQL CPU 사용율 높은 쿼리 찾기/락걸린 SQL 찾아보기
·
Programming/Database
CPU 사용율 높은 쿼리 찾기USE masterSELECT 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 ..