0 out of 1 rated this helpful - Rate this topic

SQL Server Operating System Related Dynamic Management Views

SQL Server 2005

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

Reference

Dynamic Management Views and Functions

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD