Search
Winners

Win Prizes

Social Presence
Twitter Twitter LinkedIn YouTube Google

Like us on Facebook
Advertisements
Top Articles Author
Wed, 20-Aug-2014 Authors
All Time Authors
Vishal@Neeraj
31600
Rajkatie
20600
Bharathi Cherukuri
18040

Latest members | More ...


(Statistics delayed by 5 minutes)
 Interview Question

What is the purpose of sys.dm_os_ring_buffers?

 Posted by Niladri.Biswas on 7/26/2012 | Category: Sql Server Interview questions | Views: 1061 | 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 

Found interesting? Add this to:



Comments or Responses

Login to post response