Dynamic Management Views
SQL Server 2008 adds five new dynamic management views to return memory-related information about SQL Server:
• sys.dm_os_memory_brokers
—Returns information about memory brokers, the components that track memory allocations
• sys.dm_os_memory_nodes
—Returns memory allocation information for memory allocated through SQL Server Memory Manager
• sys.dm_os_nodes
—Returns information about SQL OS memory nodes, internal structures of SQL OS that abstract hardware processor locality
• sys.dm_os_process_memory
—Returns complete information about memory allocated to SQL Server process space
• sys.dm_os_sys_memory
—Describes the memory state for the operation system
In addition, the cpu_ticks_in_ms
column in the sys.dm_os_sys_info ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.