| title | sys.dm_os_ring_buffers (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | sys.dm_os_ring_buffers (Transact-SQL) | ||||
| author | dimitri-furman | ||||
| ms.author | dfurman | ||||
| ms.reviewer | randolphwest | ||||
| ms.date | 05/09/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| f1_keywords |
|
||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| monikerRange | =azuresqldb-current || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current | ||||
| ms.custom |
|
[!INCLUDE sql-asdb-asdbmi-fabricsqldb]
Each row represents a record in a ring buffer of a specific type.
| Column name | Data type | Description |
|---|---|---|
ring_buffer_address |
varbinary(8) | [!INCLUDE ssinternalonly-md] Not nullable. |
ring_buffer_type |
nvarchar(60) | The type of the ring buffer record. Not nullable. |
timestamp |
bigint | The time when a ring buffer record was added, in milliseconds since the computer started. Not nullable. |
record |
nvarchar(max) | Identified for informational purposes only. Not supported unless described in the official Microsoft product documentation, or used as directed by Microsoft for diagnostic and troubleshooting purposes. Future compatibility is not guaranteed. Nullable. |
ring_buffer_group |
nvarchar(60) | [!INCLUDE ssinternalonly-md] Not nullable. Applies to: [!INCLUDE sssql25-md] |
create_time |
datetime2 | The time when a ring buffer record was added, in the local time of the [!INCLUDE ssDE-md] instance. Not nullable. Applies to: [!INCLUDE sssql25-md] |
A ring buffer is a memory structure within the [!INCLUDE ssDE-md] that is limited to a fixed number of records. As new records arrive, older records are removed.
Records in ring buffers contain diagnostic data for the [!INCLUDE ssDE-md]. Most ring buffer types are used for internal purposes and aren't supported, unless described in the official Microsoft product documentation. For example, you can use ring buffers to obtain health information about Always On availability groups.
The sys.dm_os_ring_buffers DMV can also be used as directed by Microsoft for diagnostic and troubleshooting purposes.
[!INCLUDE sssql19-md] and earlier versions require the VIEW SERVER STATE permission.
[!INCLUDE sssql22-md] and later versions, and [!INCLUDE ssazuremi-md], require the VIEW SERVER PERFORMANCE STATE permission on the server.
On [!INCLUDE ssazure-sqldb] Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerPerformanceStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE PERFORMANCE STATE permission on the database, or membership in the ##MS_ServerPerformanceStateReader## server role is required.