| title | SQL and Parallel Data Warehouse Dynamic Management Views | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/15/2017 | |
| ms.prod | ||
| ms.prod_service | sql-data-warehouse, pdw | |
| ms.reviewer | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | e713365e-d44c-4b66-84c9-81a1bcc32414 | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg | |
| monikerRange | >= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw-md]
This topic lists the [!INCLUDEssSDW] and [!INCLUDEssPDW] dynamic management views (DMVs).
All [!INCLUDEssSDW] and [!INCLUDEssPDW] DMVs begin with sys.dm_pdw.
The following dynamic management views apply to both [!INCLUDEssSDW] 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)
[!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)