SQL Server 环形缓冲区(Ring Buffer) -- RING_BUFFER_MEMORY_BROKER 诊断内部内存压力
/*RING_BUFFER_MEMORY_BROKER
Identity internal memory pressure.
Look at the 3 consumers of Memory
for SHRINK Notification
1.cache
2.query compilations
3.query executions
*/
select
CAST(record AS XML)
,CAST(record AS XML).value('/Record/@time','bigint') as time
,CAST(record as XML).value('/Record/MemoryBroker/Broker','varchar(50)') as Broker
,CAST(record as XML).value('/Record/MemoryBroker/Notification','varchar(20)') as Notification
,CAST(record as XML).value('/Record/MemoryBroker/MemoryRatio','int') as MemoryRatio
from
sys.dm_os_ring_buffers
where
ring_buffer_type = 'RING_BUFFER_Memory_broker'
order by
CAST(record as XML).value('/Record/MemoryBroker/Broker','varchar(50)') asc,
CAST(record as XML).value('/Record/MemoryBroker/Notification','varchar(20)') asc
页:
[1]