Vues de gestion dynamique SQL Server liées au système d'exploitation (Transact-SQL)SQL Server Operating System Related Dynamic Management Views (Transact-SQL)

S’APPLIQUE À : ouiSQL Server (à partir de 2008) nonAzure SQL Database nonAzure SQL Data Warehouse nonParallel Data Warehouse APPLIES TO: yesSQL Server (starting with 2008) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Cette section présente les vues de gestion dynamique associées au système d'exploitation SQL ServerSQL Server (SQLOS).This section contains the dynamic management views that are associated with the SQL ServerSQL Server Operating System (SQLOS). Le système d'exploitation SQL Server est chargé de gérer les ressources système propres à SQL ServerSQL Server.The SQLOS is responsible for managing operating system resources that are specific to SQL ServerSQL Server.

sys.dm_os_buffer_descriptors (Transact-SQL)sys.dm_os_buffer_descriptors (Transact-SQL) sys.dm_os_memory_pools (Transact-SQL)sys.dm_os_memory_pools (Transact-SQL)
sys.dm_os_child_instances (Transact-SQL)sys.dm_os_child_instances (Transact-SQL) sys.dm_os_nodes (Transact-SQL)sys.dm_os_nodes (Transact-SQL)
sys.dm_os_cluster_nodes (Transact-SQL)sys.dm_os_cluster_nodes (Transact-SQL) sys.dm_os_performance_counters (Transact-SQL)sys.dm_os_performance_counters (Transact-SQL)
sys.dm_os_dispatcher_pools (Transact-SQL)sys.dm_os_dispatcher_pools (Transact-SQL) sys.dm_os_process_memory (Transact-SQL)sys.dm_os_process_memory (Transact-SQL)
sys.dm_os_host_info (Transact-SQL)sys.dm_os_host_info (Transact-SQL) sys.dm_os_schedulers (Transact-SQL)sys.dm_os_schedulers (Transact-SQL)
sys.dm_os_hosts (Transact-SQL)sys.dm_os_hosts (Transact-SQL) sys.dm_os_spinlock_statssys.dm_os_spinlock_stats
sys.dm_os_job_object (Transact-SQL)sys.dm_os_job_object (Transact-SQL) sys.dm_os_stacks (Transact-SQL)sys.dm_os_stacks (Transact-SQL)
sys.dm_os_latch_stats (Transact-SQL)sys.dm_os_latch_stats (Transact-SQL) sys.dm_os_sys_info (Transact-SQL)sys.dm_os_sys_info (Transact-SQL)
sys.dm_os_loaded_modules (Transact-SQL)sys.dm_os_loaded_modules (Transact-SQL) sys.dm_os_sys_memory (Transact-SQL)sys.dm_os_sys_memory (Transact-SQL)
sys.dm_os_memory_brokers (Transact-SQL)sys.dm_os_memory_brokers (Transact-SQL) sys.dm_os_tasks (Transact-SQL)sys.dm_os_tasks (Transact-SQL)
sys.dm_os_memory_cache_clock_hands (Transact-SQL)sys.dm_os_memory_cache_clock_hands (Transact-SQL) sys.dm_os_threads (Transact-SQL)sys.dm_os_threads (Transact-SQL)
sys.dm_os_memory_cache_counters (Transact-SQL)sys.dm_os_memory_cache_counters (Transact-SQL) sys.dm_os_virtual_address_dump (Transact-SQL)sys.dm_os_virtual_address_dump (Transact-SQL)
sys.dm_os_memory_cache_entries (Transact-SQL)sys.dm_os_memory_cache_entries (Transact-SQL) sys.dm_os_volume_stats (Transact-SQL)sys.dm_os_volume_stats (Transact-SQL)
sys.dm_os_memory_cache_hash_tables (Transact-SQL)sys.dm_os_memory_cache_hash_tables (Transact-SQL) sys.dm_os_wait_stats (Transact-SQL)sys.dm_os_wait_stats (Transact-SQL)
sys.dm_os_memory_clerks (Transact-SQL)sys.dm_os_memory_clerks (Transact-SQL) sys.dm_os_waiting_tasks (Transact-SQL)sys.dm_os_waiting_tasks (Transact-SQL)
sys.dm_os_memory_nodes (Transact-SQL)sys.dm_os_memory_nodes (Transact-SQL) sys.dm_os_windows_info (Transact-SQL)sys.dm_os_windows_info (Transact-SQL)
sys.dm_os_memory_objects (Transact-SQL)sys.dm_os_memory_objects (Transact-SQL) sys.dm_os_workers (Transact-SQL)sys.dm_os_workers (Transact-SQL)

Ce qui suit SQL ServerSQL Server sont des vues de gestion dynamique liées au système d’exploitation Identifié à titre d'information uniquement.Identified for informational purposes only. Non pris en charge.Not supported. La compatibilité future n'est pas garantie.Future compatibility is not guaranteed..The following SQL ServerSQL Server Operating System-related dynamic management views are Identifié à titre d'information uniquement.Identified for informational purposes only. Non pris en charge.Not supported. La compatibilité future n'est pas garantie.Future compatibility is not guaranteed..

sys.dm_os_function_symbolic_namesys.dm_os_function_symbolic_name sys.dm_os_ring_bufferssys.dm_os_ring_buffers
sys.dm_os_memory_allocationssys.dm_os_memory_allocations sys.dm_os_sublatchessys.dm_os_sublatches
sys.dm_os_worker_local_storagesys.dm_os_worker_local_storage

Voir aussiSee Also

Fonctions et vues de gestion dynamique (Transact-SQL)Dynamic Management Views and Functions (Transact-SQL)