| title | Monitor with system views |
|---|---|
| description | This article lists the system views that you can use for monitoring the Analytics Platform System (PDW) appliance. |
| author | charlesfeddersen |
| ms.author | charlesf |
| ms.reviewer | martinle |
| ms.date | 12/04/2023 |
| ms.service | sql |
| ms.subservice | data-warehouse |
| ms.topic | concept-article |
This article lists the system views that you can use for monitoring Analytics Platform System (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.
:::image type="content" source="./media/monitor-the-appliance-by-using-system-views/PDW_system_views_alerts.png" alt-text="A diagram of Analytics Platform System (PDW) system views alerts.":::
| 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 |