| title | ms.custom | ms.date | ms.reviewer | ms.suite | ms.tgt_pltfrm | ms.topic | ms.assetid | caps.latest.revision | author |
|---|---|---|---|---|---|---|---|---|---|
Monitor the Appliance by Using System Views (Analytics Platform System) |
na |
01/05/2017 |
na |
na |
na |
article |
d6e34c16-12ba-4a6f-80a7-391bca5ba534 |
8 |
BarbKess |
This topic lists the system views that you can use for monitoring SQL Server PDW.
SQL Server PDW includes comprehensive system views that enable you to obtain detailed information about the appliance health, state, and performance. This table provides links to system views that can be used for each monitoring capability.
| Information Type | Related System Views |
| Overall status of the appliance | sys.dm_pdw_sys_info |
| Alerts | sys.pdw_health_alerts sys.dm_pdw_component_health_alerts sys.dm_pdw_component_health_active_alerts sys.dm_pdw_component_health_status |
| Appliance components and their status | sys.pdw_health_component_groups sys.pdw_health_components sys.pdw_health_component_properties sys.pdw_health_component_status_mappings sys.dm_pdw_nodes |
| Monitor requests (including queries, loads, backups, and restores) | sys.dm_pdw_exec_sessions sys.dm_pdw_exec_requests sys.dm_pdw_request_steps sys.dm_pdw_sql_requests sys.dm_pdw_dms_workers sys.dm_pdw_waits sys.dm_pdw_errors sys.pdw_distributions |
| Monitor additional information for loads, backups, and restores. | sys.pdw_loader_backup_runs sys.pdw_loader_backup_run_details sys.pdw_loader_run_stages |
| OS-level logs and performance information | sys.dm_pdw_os_performance_counters sys.dm_pdw_os_event_logs sys.dm_pdw_os_threads |