Monitor the appliance with system views - Analytics Platform System

This article lists the system views that you can use for monitoring Analytics Platform System (PDW).

Monitor the Appliance by Using System Views

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

Related content

• Appliance monitoring for Analytics Platform System