Posted By

ztuner on 10/03/12

Tagged

Versions (?)

Last Edited at 10/03/12 08:09am

Statistics

Viewed 350 times

Favorited by 0 user(s)

Related snippets

Memory Analysis

/ Published in: SQL

System Memory Analysis for SQL Server

Highlighted TextExpand

SELECT mxml.value('(//Record/@time)[1]','bigint') as NotificationTime
,mxml.value('(//Record/ResourceMonitor/Notification)[1]','nvarchar(36)') as RM_Notification
,mxml.value('(//Record/ResourceMonitor/Indicators)[1]','int') as RM_Indicators
,mxml.value('(//Record/ResourceMonitor/NodeId)[1]','bigint') as RM_NodeID
,mxml.value('(//Record/MemoryNode/@id)[1]','bigint') as MemNode_ID
,mxml.value('(//Record/MemoryNode/ReservedMemory)[1]','bigint')/1024 as MemNode_Reserved_MB
,mxml.value('(//Record/MemoryNode/CommittedMemory)[1]','bigint')/1024 as MemNode_Committed_MB
,mxml.value('(//Record/MemoryNode/SharedMemory)[1]','bigint')/1024 as MemNode_Shared_MB
,mxml.value('(//Record/MemoryNode/AWEMemory)[1]','bigint')/1024 as MemNode_AWE_MB
,mxml.value('(//Record/MemoryNode/SinglePagesMemory)[1]','bigint')/1024 as MemNode_SinglePages_MB
,mxml.value('(//Record/MemoryNode/MultiplePagesMemory)[1]','bigint')/1024 as MemNode_MultiPages_MB
,mxml.value('(//Record/MemoryNode/CachedMemory)[1]','bigint')/1024 as MemNode_Cached_MB
,mxml.value('(//Record/MemoryRecord/MemoryUtilization)[1]','int')/1024 as Memory_Utilization_MB
,mxml.value('(//Record/MemoryRecord/TotalPhysicalMemory)[1]','bigint')/1024 as TotalPhysMemory_MB
,mxml.value('(//Record/MemoryRecord/AvailablePhysicalMemory)[1]','bigint')/1024 as AvailPhysMemory_MB
,mxml.value('(//Record/MemoryRecord/TotalPageFile)[1]','bigint')/1024 as TotalPF_MB
,mxml.value('(//Record/MemoryRecord/AvailablePageFile)[1]','bigint')/1024 as AvailPF_MB
,mxml.value('(//Record/MemoryRecord/TotalVirtualAddressSpace)[1]','bigint')/1024 as TotalVAS_MB
,mxml.value('(//Record/MemoryRecord/AvailableVirtualAddressSpace)[1]','bigint')/1024 as AvailVAS_MB
,mxml.value('(//Record/MemoryRecord/AvailableExtendedVirtualAddressSpace)[1]','bigint')/1024 as AvailExtendedVAS_MB
FROM (SELECT CAST([record] AS XML)
FROM [sys].[dm_os_ring_buffers]
WHERE [ring_buffer_type] = 'RING_BUFFER_RESOURCE_MONITOR') AS R(mxml)
ORDER BY [NotificationTime] DESC

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.