I am attempting to add a query for monitor recent CPU usage for our SQL servers into an SSRS dashboard. I have encountered numerous examples online recommending querying the sys.dm_os_ring_buffers DMV, where the relevant CPU information can be extracted from the XML records where
ring_buffer_type = N’RING_BUFFER_SCHEDULER_MONITOR’
However, none of our instances return any rows for this ring_buffer_type value. There is plenty of data within the DMV for other ring_buffer_type values including RING_BUFFER_SCHEDULER, but none for RING_BUFFER_SCHEDULER_MONITOR.
To clarify, if I run hte following query :
SELECT *FROM sys.dm_os_ring_buffers WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR'
then it always comes up empty.
I am wondering if something needs to be enabled at the server or DB level to allow the recording of this data but have been unable to locate this information. Any help would be appreciated. All of our instances are on SQL Server 2016
Go to Source