Exibições de gerenciamento dinâmico do SQL e Parallel data warehouseSQL and Parallel Data Warehouse Dynamic Management Views

APLICA-SE A: nãoSQL Server nãoBanco de Dados SQL do Azure simAzure Synapse Analytics (SQL DW) simParallel Data Warehouse APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

Este tópico lista as SQL Data WarehouseSQL Data Warehouse DMVs Parallel Data WarehouseParallel Data Warehouse (exibições de gerenciamento dinâmico).This topic lists the SQL Data WarehouseSQL Data Warehouse and Parallel Data WarehouseParallel Data Warehouse dynamic management views (DMVs).

Todos SQL Data WarehouseSQL Data Warehouse e Parallel Data WarehouseParallel Data Warehouse DMVs começam com 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 Warehousee Parallel Data WarehouseParallel Data Warehouse exibições de gerenciamento dinâmicoand Parallel Data WarehouseParallel Data Warehouse Dynamic Management Views

As exibições de gerenciamento dinâmico a seguir SQL Data WarehouseSQL Data Warehouse se Parallel Data WarehouseParallel Data Warehouseaplicam ao e ao:The 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 Warehouse Exibições de gerenciamento dinâmicoDynamic Management Views

As exibições de gerenciamento dinâmico a SQL Data WarehouseSQL Data Warehouse seguir se aplicam somente a: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-(de Transact-SQL de texto)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 (versão prévia)sys.dm_workload_management_workload_groups_stats (Transact-SQL) (Preview)

Parallel Data WarehouseParallel Data Warehouse Exibições de gerenciamento dinâmicoDynamic Management Views

As exibições de gerenciamento dinâmico a Parallel Data WarehouseParallel Data Warehouse seguir se aplicam somente a: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)

Consulte TambémSee Also

Exibições e funções de gerenciamento dinâmico (Transact-SQL)Dynamic Management Views and Functions (Transact-SQL)