| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | dev_langs | monikerRange | |
|---|---|---|---|---|---|---|---|---|---|---|
SQL and Parallel Data Warehouse Dynamic Management Views |
SQL and Parallel Data Warehouse Dynamic Management Views |
rwestMSFT |
randolphwest |
05/28/2021 |
sql |
data-warehouse |
reference |
|
>=aps-pdw-2016||=azure-sqldw-latest |
[!INCLUDEapplies-to-version/asa-pdw]
This topic lists the [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW] dynamic management views (DMVs).
All [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW] DMVs begin with sys.dm_pdw.
Note
[!INCLUDEsynapse-analytics-od-unsupported-syntax]
[!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW] Dynamic Management Views
The following dynamic management views apply to both [!INCLUDEssazuresynapse-md] and [!INCLUDEssPDW]:
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)
[!INCLUDEssazuresynapse-md] Dynamic Management Views
The following dynamic management views apply to [!INCLUDEssazuresynapse-md] 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)
[!INCLUDEssPDW] Dynamic Management Views
The following dynamic management views apply to [!INCLUDEssPDW] 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)