Dela via

SQL Server Operating System Related Dynamic Management Views

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

sys.dm_os_buffer_descriptors

sys.dm_os_memory_pools

sys.dm_os_child_instances

sys.dm_os_performance_counters

sys.dm_os_cluster_nodes

sys.dm_os_schedulers

sys.dm_os_hosts

sys.dm_os_stacks

sys.dm_os_latch_stats

sys.dm_os_sys_info

sys.dm_os_loaded_modules

sys.dm_os_tasks

sys.dm_os_memory_cache_clock_hands

sys.dm_os_threads

sys.dm_os_memory_cache_counters

sys.dm_os_virtual_address_dump

sys.dm_os_memory_cache_entries

sys.dm_os_wait_stats

sys.dm_os_memory_cache_hash_tables

sys.dm_os_waiting_tasks

sys.dm_os_memory_clerks

sys.dm_os_workers

sys.dm_os_memory_objects

The following SQL Server Operating System related dynamic management views are for internal use only.

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

Reference

Dynamic Management Views and Functions

Help and Information

Getting SQL Server 2005 Assistance