Etiket: SQL Server CPU

SQL Server CPU Kullanım raporu sorgusu

SELECT TOP 200 q.text ,DB_NAME(DatabaseID) AS [DatabaseName] ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (total_worker_time)) / 1000000) AS [CPU_Time_sn] ,qs.execution_count ,CONVERT(NUMERIC(10, 2), (CONVERT(NUMERIC, (total_worker_time)) / qs.execution_count) / 1000000) AS AVG_Time ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (qs.last_worker_time)) / 1000000) AS last_worker_time ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (qs.min_worker_time)) / 1000000) AS min_worker_time ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (qs.max_worker_time)) / 1000000) AS max_worker_time ,CONVERT(NUMERIC(10, 2), CONVERT(NUMERIC, (qs.last_elapsed_time)) / […]