What is the purpose of sys.dm_os_ring_buffers?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 3077 | Points: 40
Answer:

This DMV uses RING_BUFFER_RESOURCE_MONITOR and gives information from resource monitor notifications to identify memory state changes. Internally, SQL Server has a framework that monitors different memory pressures. When the memory state changes, the resource monitor task generates a notification. This notification is used internally by the components to adjust their memory usage according to the memory state.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response