| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | dev_langs | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Server Operating System Related Dynamic Management Views (Transact-SQL) |
Dynamic management views (DMVs) associated with SQL Server Operating System (SQLOS). |
rwestMSFT |
randolphwest |
01/28/2025 |
sql |
system-objects |
reference |
|
|
[!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_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_ring_bufferssys.dm_os_sublatchessys.dm_os_worker_local_storage