Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback
Community Content
In this section
Statistics Annotations (0)
Other versions are also available for the following:
SQL Server 2008 Books Online (December 2008)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)

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

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_hosts (Transact-SQL)

sys.dm_os_schedulers (Transact-SQL)

sys.dm_os_latch_stats (Transact-SQL)

sys.dm_os_stacks (Transact-SQL)

sys.dm_os_loaded_modules (Transact-SQL)

sys.dm_os_sys_info (Transact-SQL)

sys.dm_os_memory_brokers (Transact-SQL)

sys.dm_os_sys_memory (Transact-SQL)

sys.dm_os_memory_cache_clock_hands (Transact-SQL)

sys.dm_os_tasks (Transact-SQL)

sys.dm_os_memory_cache_counters (Transact-SQL)

sys.dm_os_threads (Transact-SQL)

sys.dm_os_memory_cache_entries (Transact-SQL)

sys.dm_os_virtual_address_dump (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_workers (Transact-SQL)

sys.dm_os_memory_objects (Transact-SQL)

 

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_ring_buffers

sys.dm_os_memory_allocations

sys.dm_os_sublatches

sys.dm_os_worker_local_storage

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker