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)

CETTE RUBRIQUE S’APPLIQUE À :ouiSQL Server (à partir de la version 2008)nonAzure SQL DatabasenonAzure SQL Data Warehouse nonParallel Data Warehouse THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure 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_infosys.dm_os_host_info 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_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)

Les vues de gestion dynamique suivantes liées au système d'exploitation SQL ServerSQL Server sont 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)