Understanding CPU utilization history can sometimes be needed for diagnosing system or performance on a SQL Server instance. By analyzing historical CPU data, you can identify patterns, trends, and anomalies that help improve resource allocation and enhance overall system efficiency.

In this blog post, I’m sharing a SQL script that will retrieve CPU utilization history in one minute intervals for the last 4 hours. Hope it’s useful!

Get CPU Utilization History SQL Server

Copy/Paste the SQL Script below into your query window and run to get the CPU utilization history:

This query returns data from the sys.dm_os_ring_buffers DMV, which is available MSSQL 2019 and above. It looks like this DMV was released to help with the monitoring of Linux SQL Servers.