SQL Server Ring Buffer--Introduction to the relationship between SQL Server and ring buffer

SQL Server Ring Buffer--relationship between SQL Server and ring buffer

The SQL Server operating system (SQLOS) is responsible for managing SQL Server-specific operating system resources. One of the related dynamic management attempts sys.dm_os_ring_buffers will be identified as informational only. No support is provided. No future compatibility is guaranteed.

First look at the different ring buffer types recorded.

Select distinct Ring_buffer_type from Sys.dm_os_ring_buffers

650) this.width=650; "title=" clip_image001 "style=" Border-top:0px;border-right:0px;border-bottom:0px;border-left : 0px; "alt=" clip_image001 "src=" http://s3.51cto.com/wyfs02/M01/54/11/wKiom1R25V6TKNY5AAD4rX8ccT0471.jpg "height=" 201 "border=" 0 "/>

Each type records a large number of records in XML format. These ring buffer records contain the smallest system output that helps to provide a better idea of the change in the state of the analysis.

Ring_buffer_resource_monitor-Monitoring the use of resources, can provide information to analyze the physical memory pressure.

Ring_buffer_scheduler_monitor-Monitor the status of the logical scheduler, as well as the health record type.

Ring_buffer_memory_broker-Monitors the behavior of internal memory agents used to balance memory allocations between caches.

Ring_buffer_security_error-Security-related error message. For example, a login failure may have more detailed information about the operating system error code.

Ring_buffer_scheduler-The actual scheduler activity, like a context switch. You can reconstruct the execution order from the portal.

Ring_buffer_exception-Any exception that is issued by the server. SQL internally throws an error, so you can also see SQL errors.

Ring_buffer_connectivity-critical connection information, which is useful for tracking connection failures.

This article is from the "Dripping Stone Wear" blog, please be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1583387

SQL Server Ring Buffer--Introduction to the relationship between SQL Server and ring buffer