封云亭 发表于 2018-10-23 11:57:34

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]
查看完整版本: SQL Server 环形缓冲区(Ring Buffer) -- RING_BUFFER_MEMORY_BROKER 诊断内部内存压力