SQL and Parallel Data Warehouse Dynamic Management Views

Applies to: yesAzure Synapse Analytics yesParallel Data Warehouse

This topic lists the SQL Data Warehouse and Parallel Data Warehouse dynamic management views (DMVs).

All SQL Data Warehouse and Parallel Data Warehouse DMVs begin with sys.dm_pdw.

SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views

The following dynamic management views apply to both SQL Data Warehouse and Parallel Data Warehouse:

sys.dm_pdw_dms_cores (Transact-SQL)

sys.dm_pdw_dms_external_work (Transact-SQL)

sys.dm_pdw_dms_workers (Transact-SQL)

sys.dm_pdw_errors (Transact-SQL)

sys.dm_pdw_exec_connections (Transact-SQL)

sys.dm_pdw_exec_requests (Transact-SQL)

sys.dm_pdw_exec_sessions (Transact-SQL)

sys.dm_pdw_hadoop_operations (Transact-SQL)

sys.dm_pdw_lock_waits (Transact-SQL)

sys.dm_pdw_nodes (Transact-SQL)

sys.dm_pdw_nodes_database_encryption_keys (Transact-SQL)

sys.dm_pdw_os_threads (Transact-SQL)

sys.dm_pdw_request_steps (Transact-SQL)

sys.dm_pdw_resource_waits (Transact-SQL)

sys.dm_pdw_sql_requests (Transact-SQL)

sys.dm_pdw_sys_info (Transact-SQL)

sys.dm_pdw_wait_stats (Transact-SQL)

sys.dm_pdw_waits (Transact-SQL)

SQL Data Warehouse Dynamic Management Views

The following dynamic management views apply to SQL Data Warehouse only:

sys.dm_pdw_nodes_exec_query_plan (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_sql-text (Transact-SQL)

sys.dm_pdw_nodes_exec_text_query_plan (Transact-SQL)

sys.dm_workload_management_workload_groups_stats (Transact-SQL) (Preview)

Parallel Data Warehouse Dynamic Management Views

The following dynamic management views apply to Parallel Data Warehouse only:

sys.dm_pdw_component_health_active_alerts (Transact-SQL)

sys.dm_pdw_component_health_alerts (Transact-SQL)

sys.dm_pdw_component_health_status (Transact-SQL)

sys.dm_pdw_diag_processing_stats (Transact-SQL)

sys.dm_pdw_network_credentials (Transact-SQL)

sys.dm_pdw_node_status (Transact-SQL)

sys.dm_pdw_os_event_logs (Transact-SQL)

sys.dm_pdw_os_performance_counters (Transact-SQL)

sys.dm_pdw_query_stats_xe (Transact-SQL)

sys.dm_pdw_query_stats_xe_file (Transact-SQL)

See Also

Dynamic Management Views and Functions (Transact-SQL)