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

title	SQL Server Operating System Related Dynamic Management Views (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	04/17/2018
ms.prod	sql
ms.reviewer
ms.suite	sql
ms.technology	system-objects
ms.tgt_pltfrm
ms.topic	language-reference
dev_langs	TSQL
helpviewer_keywords	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
ms.assetid	3030c86a-0a74-4fed-ac0f-392e244cb965
caps.latest.revision	29
author	stevestein
ms.author	sstein
manager	craigg

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

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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

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_host_info (Transact-SQL)	sys.dm_os_schedulers (Transact-SQL)
sys.dm_os_hosts (Transact-SQL)	sys.dm_os_stacks (Transact-SQL)
sys.dm-os-job-object (Transact-SQL)
sys.dm_os_latch_stats (Transact-SQL)	sys.dm_os_sys_info (Transact-SQL)
sys.dm_os_loaded_modules (Transact-SQL)	sys.dm_os_sys_memory (Transact-SQL)
sys.dm_os_memory_brokers (Transact-SQL)	sys.dm_os_tasks (Transact-SQL)
sys.dm_os_memory_cache_clock_hands (Transact-SQL)	sys.dm_os_threads (Transact-SQL)
sys.dm_os_memory_cache_counters (Transact-SQL)	sys.dm_os_virtual_address_dump (Transact-SQL)
sys.dm_os_memory_cache_entries (Transact-SQL)	sys.dm_os_volume_stats (Transact-SQL)
sys.dm_os_memory_cache_hash_tables (Transact-SQL)	sys.dm_os_wait_stats (Transact-SQL)
sys.dm_os_memory_clerks (Transact-SQL)	sys.dm_os_waiting_tasks (Transact-SQL)
sys.dm_os_memory_nodes (Transact-SQL)	sys.dm_os_windows_info (Transact-SQL)
sys.dm_os_memory_objects (Transact-SQL)	sys.dm_os_workers (Transact-SQL)

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

sys.dm_os_function_symbolic_name	sys.dm_os_ring_buffers
sys.dm_os_memory_allocations	sys.dm_os_sublatches
sys.dm_os_worker_local_storage

See Also

Dynamic Management Views and Functions (Transact-SQL)