Dynamische Verwaltungssichten in Verbindung mit dem SQL Server-Betriebssystem (Transact-SQL)SQL Server Operating System Related Dynamic Management Views (Transact-SQL)

GILT FÜR: jaSQL Server neinAzure SQL-DatenbankneinAzure SQL Data Warehouse neinParallel Data WarehouseAPPLIES TO: yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Dieser Abschnitt enthält die dynamischen Verwaltungssichten, die mit dem SQL ServerSQL Server-Betriebssystem (SQLOS) verbunden sind.This section contains the dynamic management views that are associated with the SQL ServerSQL Server Operating System (SQLOS). SQLOS ist für die Verwaltung von SQL ServerSQL Server-spezifischen Betriebssystemressourcen zuständig.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)

Die folgenden SQL ServerSQL Server betriebssystembezogene dynamischen Verwaltungssichten sind Nur für Informationszwecke identifiziert.Identified for informational purposes only. Wird nicht unterstützt.Not supported. Zukünftige Kompatibilität wird nicht sichergestellt.Future compatibility is not guaranteed..The following SQL ServerSQL Server Operating System-related dynamic management views are Nur für Informationszwecke identifiziert.Identified for informational purposes only. Wird nicht unterstützt.Not supported. Zukünftige Kompatibilität wird nicht sichergestellt.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

Siehe auchSee Also

Dynamische Verwaltungssichten und -funktionen (Transact-SQL)Dynamic Management Views and Functions (Transact-SQL)