SQL-und parallele Data Warehouse dynamische Verwaltungs SichtenSQL and Parallel Data Warehouse Dynamic Management Views

Gilt für: NeinSQL ServerNeinAzure SQL-DatenbankJaAzure Synapse Analytics (SQL DW) JaParallel Data Warehouse APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

In diesem Thema werden SQL Data WarehouseSQL Data Warehouse die Parallel Data WarehouseParallel Data Warehouse dynamischen Verwaltungs Sichten und (Dynamic Management Views, DMVs) aufgelistet.This topic lists the SQL Data WarehouseSQL Data Warehouse and Parallel Data WarehouseParallel Data Warehouse dynamic management views (DMVs).

Alle SQL Data WarehouseSQL Data Warehouse und Parallel Data WarehouseParallel Data Warehouse DMVs beginnen mit sys. dm_pdw.All SQL Data WarehouseSQL Data Warehouse and Parallel Data WarehouseParallel Data Warehouse DMVs begin with sys.dm_pdw.

SQL Data WarehouseSQL Data Warehouseund Parallel Data WarehouseParallel Data Warehouse dynamische Verwaltungs Sichtenand Parallel Data WarehouseParallel Data Warehouse Dynamic Management Views

Die folgenden dynamischen Verwaltungs Sichten gelten für SQL Data WarehouseSQL Data Warehouse und: Parallel Data WarehouseParallel Data WarehouseThe following dynamic management views apply to both SQL Data WarehouseSQL Data Warehouse and Parallel Data WarehouseParallel Data Warehouse:

sys. dm_pdw_dms_cores (Transact-SQL-)sys.dm_pdw_dms_cores (Transact-SQL)

sys. dm_pdw_dms_external_work (Transact-SQL-)sys.dm_pdw_dms_external_work (Transact-SQL)

sys. dm_pdw_dms_workers (Transact-SQL-)sys.dm_pdw_dms_workers (Transact-SQL)

sys. dm_pdw_errors (Transact-SQL-)sys.dm_pdw_errors (Transact-SQL)

sys. dm_pdw_exec_connections (Transact-SQL-)sys.dm_pdw_exec_connections (Transact-SQL)

sys. dm_pdw_exec_requests (Transact-SQL-)sys.dm_pdw_exec_requests (Transact-SQL)

sys. dm_pdw_exec_sessions (Transact-SQL-)sys.dm_pdw_exec_sessions (Transact-SQL)

sys. dm_pdw_hadoop_operations (Transact-SQL-)sys.dm_pdw_hadoop_operations (Transact-SQL)

sys. dm_pdw_lock_waits (Transact-SQL-)sys.dm_pdw_lock_waits (Transact-SQL)

sys. dm_pdw_nodes (Transact-SQL-)sys.dm_pdw_nodes (Transact-SQL)

sys. dm_pdw_nodes_database_encryption_keys (Transact-SQL-)sys.dm_pdw_nodes_database_encryption_keys (Transact-SQL)

sys. dm_pdw_os_threads (Transact-SQL-)sys.dm_pdw_os_threads (Transact-SQL)

sys. dm_pdw_request_steps (Transact-SQL-)sys.dm_pdw_request_steps (Transact-SQL)

sys. dm_pdw_resource_waits (Transact-SQL-)sys.dm_pdw_resource_waits (Transact-SQL)

sys. dm_pdw_sql_requests (Transact-SQL-)sys.dm_pdw_sql_requests (Transact-SQL)

sys. dm_pdw_sys_info (Transact-SQL-)sys.dm_pdw_sys_info (Transact-SQL)

sys. dm_pdw_wait_stats (Transact-SQL-)sys.dm_pdw_wait_stats (Transact-SQL)

sys. dm_pdw_waits (Transact-SQL-)sys.dm_pdw_waits (Transact-SQL)

SQL Data WarehouseSQL Data WarehouseDynamische Verwaltungs SichtenDynamic Management Views

Die folgenden dynamischen Verwaltungs Sichten gelten nur SQL Data WarehouseSQL Data Warehouse für:The following dynamic management views apply to SQL Data WarehouseSQL Data Warehouse only:

sys. dm_pdw_nodes_exec_query_plan (Transact-SQL-)sys.dm_pdw_nodes_exec_query_plan (Transact-SQL)

sys. dm_pdw_nodes_exec_query_profiles (Transact-SQL-)sys.dm_pdw_nodes_exec_query_profiles (Transact-SQL)

sys. dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL-)sys.dm_pdw_nodes_exec_query_statistics_xml (Transact-SQL)

sys. dm_pdw_nodes_exec_sql-Text (Transact-SQL-)sys.dm_pdw_nodes_exec_sql-text (Transact-SQL)

sys. dm_pdw_nodes_exec_text_query_plan (Transact-SQL-)sys.dm_pdw_nodes_exec_text_query_plan (Transact-SQL)

sys. dm_workload_management_workload_groups_stats (Transact-SQL-) (Vorschau)sys.dm_workload_management_workload_groups_stats (Transact-SQL) (Preview)

Parallel Data WarehouseParallel Data WarehouseDynamische Verwaltungs SichtenDynamic Management Views

Die folgenden dynamischen Verwaltungs Sichten gelten nur Parallel Data WarehouseParallel Data Warehouse für:The following dynamic management views apply to Parallel Data WarehouseParallel Data Warehouse only:

sys. dm_pdw_component_health_active_alerts (Transact-SQL-)sys.dm_pdw_component_health_active_alerts (Transact-SQL)

sys. dm_pdw_component_health_alerts (Transact-SQL-)sys.dm_pdw_component_health_alerts (Transact-SQL)

sys. dm_pdw_component_health_status (Transact-SQL-)sys.dm_pdw_component_health_status (Transact-SQL)

sys. dm_pdw_diag_processing_stats (Transact-SQL-)sys.dm_pdw_diag_processing_stats (Transact-SQL)

sys. dm_pdw_network_credentials (Transact-SQL-)sys.dm_pdw_network_credentials (Transact-SQL)

sys. dm_pdw_node_status (Transact-SQL-)sys.dm_pdw_node_status (Transact-SQL)

sys. dm_pdw_os_event_logs (Transact-SQL-)sys.dm_pdw_os_event_logs (Transact-SQL)

sys. dm_pdw_os_performance_counters (Transact-SQL-)sys.dm_pdw_os_performance_counters (Transact-SQL)

sys. dm_pdw_query_stats_xe (Transact-SQL-)sys.dm_pdw_query_stats_xe (Transact-SQL)

sys. dm_pdw_query_stats_xe_file (Transact-SQL-)sys.dm_pdw_query_stats_xe_file (Transact-SQL)

Weitere InformationenSee Also

Dynamische Verwaltungs Sichten und Funktionen (Transact-SQL-)Dynamic Management Views and Functions (Transact-SQL)