SQL Server 2005性能排错(10)

select record 
from sys.dm_os_ring_buffers 
where ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR'

<Record id="1701" type="RING_BUFFER_RESOURCE_MONITOR" time="149740267">
<ResourceMonitor>
<Notification>RESOURCE_MEMPHYSICAL_LOW</Notification> 
<Indicators>2</Indicators> 
<NodeId>0</NodeId> 
</ResourceMonitor>
<MemoryNode id="0">
<ReservedMemory>1646380</ReservedMemory> 
<CommittedMemory>432388</CommittedMemory> 
<SharedMemory>0</SharedMemory> 
<AWEMemory>0</AWEMemory> 
<SinglePagesMemory>26592</SinglePagesMemory> 
<MultiplePagesMemory>17128</MultiplePagesMemory> 
<CachedMemory>17624</CachedMemory> 
</MemoryNode>
<MemoryRecord>
<MemoryUtilization>50</MemoryUtilization> 
<TotalPhysicalMemory>3833132</TotalPhysicalMemory> 
<AvailablePhysicalMemory>3240228</AvailablePhysicalMemory> 
<TotalPageFile>5732340</TotalPageFile> 
<AvailablePageFile>5057100</AvailablePageFile> 
<TotalVirtualAddressSpace>2097024</TotalVirtualAddressSpace> 
<AvailableVirtualAddressSpace>336760</AvailableVirtualAddressSpace> 
<AvailableExtendedVirtualAddressSpace>0</AvailableExtendedVirtualAddressSpace> 
</MemoryRecord>
</Record>

select 
x.value('(//Notification)[1]', 'varchar(max)') as [Type],
x.value('(//Record/@time)[1]', 'bigint') as [Time Stamp],
x.value('(//AvailablePhysicalMemory)[1]', 'int') as [Avail Phys Mem, Kb],
x.value('(//AvailableVirtualAddressSpace)[1]', 'int') as [Avail VAS, Kb]
from 
(select cast(record as xml)
from sys.dm_os_ring_buffers 
where ring_buffer_type = 'RING_BUFFER_RESOURCE_MONITOR') as R(x)
order by
[Time Stamp] desc

select record 
from sys.dm_os_ring_buffers 
where ring_buffer_type = 'RING_BUFFER_OOM'

<Record id="7301" type="RING_BUFFER_OOM" time="345640123">
<OOM>
<Action>FAIL_VIRTUAL_COMMIT</Action> 
<Resources>4096</Resources> 
</OOM>

select
x.value('(//Record/@time)[1]', 'bigint') as [Time Stamp],
x.value('(//Notification)[1]', 'varchar(100)') as [Last Notification]
from
(select cast(record as xml)
from sys.dm_os_ring_buffers 
where ring_buffer_type = 'RING_BUFFER_MEMORY_BROKER') as R(x)
order by
[Time Stamp] desc