Skip to content

Latest commit

 

History

History
47 lines (39 loc) · 3.14 KB

sql-server-operating-system-related-dynamic-management-views-transact-sql.md

File metadata and controls

47 lines (39 loc) · 3.14 KB
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)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)
rwestMSFT
randolphwest
04/17/2018
sql
system-objects
reference
operating systems [SQL Server], dynamic management objects
SQL Operating System dynamic management objects [SQL Server]
SQL OS dynamic management objects [SQL Server]
dynamic management objects [SQL Server], SQL OS
TSQL

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

[!INCLUDE SQL Server]

This section documents dynamic management views (DMV) that are associated with [!INCLUDEssNoVersion] Operating System (SQLOS). SQLOS is responsible for managing operating system resources that are specific to [!INCLUDEssNoVersion].

:::row::: :::column span=""::: 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 :::column-end::: :::column span=""::: 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_waiting_tasks
sys.dm_os_wait_stats
sys.dm_os_windows_info
sys.dm_os_workers :::column-end::: :::row-end:::

The following [!INCLUDEssNoVersion] Operating System-related dynamic management views are [!INCLUDEssInternalOnly].

:::row::: :::column span=""::: sys.dm_os_function_symbolic_name
sys.dm_os_ring_buffers
sys.dm_os_memory_allocations :::column-end::: :::column span=""::: sys.dm_os_sublatches
sys.dm_os_worker_local_storage
:::column-end::: :::row-end:::

See Also

Dynamic Management Views and Functions (Transact-SQL)