SQL Server 2008 Ring Buffer Entries

Published Jan 15 2019 11:26 AM 100 Views
Microsoft
First published on MSDN on Mar 13, 2009

Sent: Monday, March 09, 2009 6:20 PM
Subject: Ring Buffers in SQL2008

Hi, do you have any documentation/white papers/examples about extended dmv’s or ring buffers in SQL2008?

select distinct ring_buffer_type from sys.dm_os_ring_buffers

==================================

My Reply

==================================

Nothing that I would consider advanced.

  • Each can have multiple message types.

  • The message types are XML formatted so you can see the various data points.

  • The ring buffers are included in the mini-dumps to help in troubleshooting to get a better idea of current and lead-up state.

RING_BUFFER_RESOURCE_MONITOR - Resource Monitor activity like was physical memory pressure signaled or not.
RING_BUFFER_SCHEDULER_MONITOR  - What is the state of the logical schedulers, the health record type is very helpful.
RING_BUFFER_MEMORY_BROKER  - Actions the internal memory broker is taking to balance the memory between caches.
RING_BUFFER_SECURITY_ERROR  - Errors that occur during security operations.  Ex: login failed may have more details about the OS error code and such
RING_BUFFER_SCHEDULER - Actual scheduler activity such as context switching.  You can reconstruct the execution order from these entries.
RING_BUFFER_EXCEPTION - Any exceptions encountered in the server.  SQL uses throw internally for errors so you can see SQL errors as well.
RING_BUFFER_CONNECTIVITY - Core connectivity information - useful in tracking down connection failure information


Reference:

http://blogs.msdn.com/psssql/archive/2008/03/24/how-it-works-sql-server-2005-sp2-security-ring-...

http://blogs.msdn.com/sql_protocols/archive/2008/05/20/connectivity-troubleshooting-in-sql-serv...

Bob Dorr - Principal SQL Server Escalation Engineer


%3CLINGO-SUB%20id%3D%22lingo-sub-315700%22%20slang%3D%22en-US%22%3ESQL%20Server%202008%20Ring%20Buffer%20Entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-315700%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Mar%2013%2C%202009%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3E%3CB%3ESent%3A%20%3C%2FB%3E%20Monday%2C%20March%2009%2C%202009%206%3A20%20PM%20%3CBR%20%2F%3E%20%3CB%3E%20Subject%3A%20%3C%2FB%3E%20Ring%20Buffers%20in%20SQL2008%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EHi%2C%20do%20you%20have%20any%20documentation%2Fwhite%20papers%2Fexamples%20about%20extended%20dmv%E2%80%99s%20or%20ring%20buffers%20in%20SQL2008%3F%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3Eselect%20distinct%20ring_buffer_type%20from%20sys.dm_os_ring_buffers%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EMy%20Reply%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3D%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3ENothing%20that%20I%20would%20consider%20advanced.%3C%2FP%3E%0A%20%20%3CUL%3E%0A%20%20%20%3CLI%3E%3CDIV%3EEach%20can%20have%20multiple%20message%20types.%3CP%3E%3C%2FP%3E%0A%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%3C%2FLI%3E%0A%20%20%20%3CLI%3E%3CDIV%3EThe%20message%20types%20are%20XML%20formatted%20so%20you%20can%20see%20the%20various%20data%20points.%3CP%3E%3C%2FP%3E%0A%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%3C%2FLI%3E%0A%20%20%20%3CLI%3E%3CDIV%3EThe%20ring%20buffers%20are%20included%20in%20the%20mini-dumps%20to%20help%20in%20troubleshooting%20to%20get%20a%20better%20idea%20of%20current%20and%20lead-up%20state.%3CP%3E%3C%2FP%3E%0A%20%20%20%20%3C%2FDIV%3E%0A%20%20%20%3C%2FLI%3E%0A%20%20%3C%2FUL%3E%0A%20%20%3CP%3ERING_BUFFER_RESOURCE_MONITOR%20-%20Resource%20Monitor%20activity%20like%20was%20physical%20memory%20pressure%20signaled%20or%20not.%20%3CBR%20%2F%3E%20RING_BUFFER_SCHEDULER_MONITOR%26nbsp%3B%20-%20What%20is%20the%20state%20of%20the%20logical%20schedulers%2C%20the%20health%20record%20type%20is%20very%20helpful.%20%3CBR%20%2F%3E%20RING_BUFFER_MEMORY_BROKER%26nbsp%3B%20-%20Actions%20the%20internal%20memory%20broker%20is%20taking%20to%20balance%20the%20memory%20between%20caches.%20%3CBR%20%2F%3E%20RING_BUFFER_SECURITY_ERROR%26nbsp%3B%20-%20Errors%20that%20occur%20during%20security%20operations.%26nbsp%3B%20Ex%3A%20login%20failed%20may%20have%20more%20details%20about%20the%20OS%20error%20code%20and%20such%20%3CBR%20%2F%3E%20RING_BUFFER_SCHEDULER%20-%20Actual%20scheduler%20activity%20such%20as%20context%20switching.%26nbsp%3B%20You%20can%20reconstruct%20the%20execution%20order%20from%20these%20entries.%20%3CBR%20%2F%3E%20RING_BUFFER_EXCEPTION%20-%20Any%20exceptions%20encountered%20in%20the%20server.%26nbsp%3B%20SQL%20uses%20throw%20internally%20for%20errors%20so%20you%20can%20see%20SQL%20errors%20as%20well.%20%3CBR%20%2F%3E%20RING_BUFFER_CONNECTIVITY%20-%20Core%20connectivity%20information%20-%20useful%20in%20tracking%20down%20connection%20failure%20information%3C%2FP%3E%0A%20%20%3CP%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3EReference%3A%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fpsssql%2Farchive%2F2008%2F03%2F24%2Fhow-it-works-sql-server-2005-sp2-security-ring-buffer-ring-buffer-security-error.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fpsssql%2Farchive%2F2008%2F03%2F24%2Fhow-it-works-sql-server-2005-sp2-security-ring-buffer-ring-buffer-security-error.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fblogs.msdn.com%2Fsql_protocols%2Farchive%2F2008%2F05%2F20%2Fconnectivity-troubleshooting-in-sql-server-2008-with-the-connectivity-ring-buffer.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fblogs.msdn.com%2Fsql_protocols%2Farchive%2F2008%2F05%2F20%2Fconnectivity-troubleshooting-in-sql-server-2008-with-the-connectivity-ring-buffer.aspx%20%3C%2FA%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EBob%20Dorr%20-%20Principal%20SQL%20Server%20Escalation%20Engineer%20%3CBR%20%2F%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-315700%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2013%2C%202009%20Sent%3A%20Monday%2C%20March%2009%2C%202009%206%3A20%20PM%20Subject%3A%20Ring%20Buffers%20in%20SQL2008%20%26nbsp%3BHi%2C%20do%20you%20have%20any%20documentation%2Fwhite%20papers%2Fexamples%20about%20extended%20dmv%E2%80%99s%20or%20ring%20buffers%20in%20SQL2008%3F%20select%20distinct%20ring_buffer_type%20from%20sys.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-315700%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Etroubleshooting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUtilities%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jan 15 2019 11:26 AM
Updated by: