Blog Post

SQL Server Blog
1 MIN READ

SQL Server CPU usage available in sys.dm_os_ring_buffers DMV starting SQL Server 2019 RC on Linux

Tejas Shah's avatar
Tejas Shah
Icon for Microsoft rankMicrosoft
Aug 27, 2019
Sys.dm_os_ring_buffers DMV has been a key DMV used for monitoring SQL Server by built-in tools as well as third party monitoring utilities. When SQL Server 2017 was released on Linux, unfortunately t...
Updated Sep 04, 2019
Version 2.0
SQLServerTiger
Pankaj_Mittal's avatar
Pankaj_Mittal
Copper Contributor
Jun 02, 2024

Hi Tejas Shah : We utilize this DMV to monitor SQL Server CPU utilization and fire alerts based on certain thresholds across thousands of SQL Server in our environment. We have noticed that the numbers do not align on a Windows machine as they do on a Linux machine. For example, in many cases the SQLServerCPUUtilization + NonSQLCPUUtilization >100%. Sometimes, SQLServerCPUUtilization alone exceeds 100%. Wondering if "ProcessUtilization" column in this DMV represents absolute or relative % of CPU utilization by SQL Server. An example of what we are seeing is below