SQL Server Operating System related dynamic management views (Transact-SQL)

Applies to: SQL Server

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

• sys.dm_os_buffer_descriptors
• sys.dm_os_buffer_pool_extension_configuration
• sys.dm_os_child_instances
• sys.dm_os_cluster_nodes
• sys.dm_os_cluster_properties
• sys.dm_os_dispatcher_pools
• sys.dm_os_enumerate_fixed_drives
• sys.dm_os_host_info
• sys.dm_os_hosts
• sys.dm_os_latch_stats
• sys.dm_os_loaded_modules
• sys.dm_os_memory_brokers
• sys.dm_os_memory_cache_clock_hands
• sys.dm_os_memory_cache_counters
• sys.dm_os_memory_cache_entries
• sys.dm_os_memory_cache_hash_tables
• sys.dm_os_memory_clerks
• sys.dm_os_memory_nodes
• sys.dm_os_nodes
• sys.dm_os_performance_counters
• sys.dm_os_process_memory
• sys.dm_os_ring_buffers
• sys.dm_os_schedulers
• sys.dm_os_server_diagnostics_log_configurations
• sys.dm_os_spinlock_stats
• sys.dm_os_stacks
• sys.dm_os_sys_info
• sys.dm_os_sys_memory
• sys.dm_os_tasks
• sys.dm_os_threads
• sys.dm_os_virtual_address_dump
• sys.dm_os_volume_stats
• sys.dm_os_wait_stats
• sys.dm_os_waiting_tasks
• sys.dm_os_windows_info
• sys.dm_os_workers

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_name
• sys.dm_os_memory_allocations
• sys.dm_os_sublatches
• sys.dm_os_worker_local_storage

Related content

• System dynamic management views