| title | SQL Server Operating System Related Dynamic Management Views (Transact-SQL) | ||||
|---|---|---|---|---|---|
| description | Dynamic management views (DMVs) associated with SQL Server Operating System (SQLOS). | ||||
| author | rwestMSFT | ||||
| ms.author | randolphwest | ||||
| ms.date | 01/28/2025 | ||||
| ms.service | sql | ||||
| ms.subservice | system-objects | ||||
| ms.topic | reference | ||||
| helpviewer_keywords |
|
||||
| dev_langs |
|
||||
| ms.custom |
|
[!INCLUDE SQL Server]
This section documents dynamic management views (DMVs) that are associated with [!INCLUDE ssNoVersion] Operating System (SQLOS). SQLOS is responsible for managing operating system resources that are specific to [!INCLUDE ssNoVersion].
- 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 [!INCLUDE ssNoVersion] operating system-related dynamic management views are [!INCLUDE ssInternalOnly].
sys.dm_os_function_symbolic_namesys.dm_os_memory_allocationssys.dm_os_sublatchessys.dm_os_worker_local_storage