SQL Server 2008 Ring Buffer Entries

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




Bob Dorr - Principal SQL Server Escalation Engineer

Comments (2)

  1. nacklace says:

    Jewelry is one of the oldest forms of beautification and personal

    adornment. Nowadays, it is extremely uncommon for anyone to be without a

    piece of jewelry that they own. From brooches to wedding rings to cuff

    links, jewelry has become an important part of everyday life and

    fashion.Here you'll find the Top jewellery websites, gold, diamond,

    fashion jewellery. light weight,traditional and antique jewellery in

    gold, diamond and platinum.

    Jewelry has been a regular feature across history, beginning in ancient

    times and continuing to this day.

Skip to main content