[FEATURE] Add CPU Utilization from Benjamin Nevarez

ktaranov · ktaranov · commit eee4ce3a91a4 · 2016-04-14T22:24:43.000+03:00
diff --git a/Scripts/CPU_Utilization.sql b/Scripts/CPU_Utilization.sql
@@ -0,0 +1,27 @@
+/*
+Author: Benjamin Nevarez
+Original link: http://sqlblog.com/blogs/ben_nevarez/archive/2009/07/26/getting-cpu-utilization-data-from-sql-server.aspx
+*/
+
+
+DECLARE @ts_now BIGINT;
+
+SELECT @ts_now = cpu_ticks / CONVERT(FLOAT, cpu_ticks)
+FROM   sys.dm_os_sys_info;
+
+SELECT record_id
+     , Dateadd(ms, -1 * ( @ts_now - [timestamp])
+     , Getdate()) AS EventTime
+     , sqlprocessutilization
+     , systemidle
+     , 100 - systemidle - sqlprocessutilization AS OtherProcessUtilization
+FROM   (SELECT record.value('(./Record/@id)[1]', 'int') AS record_id
+             , record.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]', 'int') AS SystemIdle
+             , record.value('(./Record/SchedulerMonitorEvent/SystemHealth/ProcessUtilization)[1]', 'int') AS SQLProcessUtilization
+             , timestamp
+ FROM   (SELECT timestamp
+              , CONVERT(XML, record) AS record
+         FROM   sys.dm_os_ring_buffers
+         WHERE  ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR'
+            AND record LIKE '%<SystemHealth>%') AS x) AS y
+ORDER BY record_id DESC;
diff --git a/Scripts/README.md b/Scripts/README.md
@@ -46,7 +46,13 @@ Tested on SQL Server version: 2008/2012/2014/2016
 ## [CPU Utilization Graphical form](CPU_Utilization_Graphical_form.sql)
 Author: Slava Murygin<br/>
 Original link: http://slavasql.blogspot.ru/2016/03/sql-server-cpu-utilization-in-graphical.html<br/>
-Tested on SQL Server version: 2008/2012/2014/2016
+Tested on SQL Server version: 2012/2014
+
+
+## [CPU Utilization](CPU_Utilization.sql)
+Author: Benjamin Nevarez<br/>
+Original link: http://sqlblog.com/blogs/ben_nevarez/archive/2009/07/26/getting-cpu-utilization-data-from-sql-server.aspx<br/>
+Tested on SQL Server version: 2014
 
 
 ## [Table count alternative](Table Count alternative.sql)
