SQL and Parallel Data Warehouse Dynamic Management Views

APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse 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)

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)