Table of contents
TOC
Collapse the table of content
Expand the table of content

Monitor the Appliance by Using System Views

Barbara Kess|Last Updated: 1/6/2017

This topic lists the system views that you can use for monitoring SQL Server PDW.

To 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.

PDW system views alerts

Information TypeRelated System Views
Overall status of the appliancesys.dm_pdw_sys_info
Alertssys.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 statussys.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 informationsys.dm_pdw_os_performance_counters

sys.dm_pdw_os_event_logs

sys.dm_pdw_os_threads

See Also

Appliance Monitoring (Analytics Platform System)

© 2017 Microsoft