MSSQL CPU占用(yòng)查詢語句 可(kě)用(yòng)于查詢CPU占用(yòng)情況
SELECT total_cpu_time, total_physical_Reads , total_execution_count, number_of_statements, s2.text--(SELECT SUBSTRING(s2.text, statement_start_offset / 2, ((CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(NVARCHAR(MAX), s2.text)) * 2) ELSE statement_end_offset END) - statement_start_offset) / 2) ) AS query_textFROM(SELECT TOP 50SUM(qs.total_worker_time) AS total_cpu_time,SUM(total_physical_r..