TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

SQL Server Operating System Related Dynamic Management Views (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

This section contains the dynamic management views that are associated with the SQL Server Operating System (SQLOS). The SQLOS is responsible for managing operating system resources that are specific to SQL Server.

sys.dm_os_buffer_descriptors (Transact-SQL)sys.dm_os_memory_pools (Transact-SQL)
sys.dm_os_child_instances (Transact-SQL)sys.dm_os_nodes (Transact-SQL)
sys.dm_os_cluster_nodes (Transact-SQL)sys.dm_os_performance_counters (Transact-SQL)
sys.dm_os_dispatcher_pools (Transact-SQL)sys.dm_os_process_memory (Transact-SQL)
sys.dm_os_hosts (Transact-SQL)sys.dm_os_schedulers (Transact-SQL)
sys.dm_os_latch_stats (Transact-SQL)sys.dm_os_stacks (Transact-SQL)
sys.dm_os_loaded_modules (Transact-SQL)sys.dm_os_sys_info (Transact-SQL)
sys.dm_os_memory_brokers (Transact-SQL)sys.dm_os_sys_memory (Transact-SQL)
sys.dm_os_memory_cache_clock_hands (Transact-SQL)sys.dm_os_tasks (Transact-SQL)
sys.dm_os_memory_cache_counters (Transact-SQL)sys.dm_os_threads (Transact-SQL)
sys.dm_os_memory_cache_entries (Transact-SQL)sys.dm_os_virtual_address_dump (Transact-SQL)
sys.dm_os_memory_cache_hash_tables (Transact-SQL)sys.dm_os_volume_stats (Transact-SQL)
sys.dm_os_memory_clerks (Transact-SQL)sys.dm_os_wait_stats (Transact-SQL)
sys.dm_os_memory_nodes (Transact-SQL)sys.dm_os_waiting_tasks (Transact-SQL)
sys.dm_os_memory_objects (Transact-SQL)sys.dm_os_windows_info (Transact-SQL)
sys.dm_os_workers (Transact-SQL)

The following SQL Server Operating System–related dynamic management views are Identified for informational purposes only. Not supported. Future compatibility is not guaranteed..

sys.dm_os_function_symbolic_namesys.dm_os_ring_buffers
sys.dm_os_memory_allocationssys.dm_os_sublatches
sys.dm_os_worker_local_storage

Dynamic Management Views and Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft