Determine Polling Frequency
This article explains how to determine the polling frequency for Analytics Platform System appliance alerts.
To Determine the Polling Frequency
Since PDW does not currently support proactive notifications when alerts occur, the monitoring solution needs to continuously poll the appliance DLLs. Internally, PDW polls the components at different intervals:
Cluster – 60 seconds
Heartbeat – 60 seconds
All other components – five minutes
Performance counters – three seconds
A common interval to poll for alerts, which is also used by System Center, is every 15 minutes. Obviously, you could query more or less frequently, but it is not recommended to poll less than every six hours.
Polling more frequently is acceptable, but polling too frequently can clutter the sys.dm_pdw_nodes_exec_requests DMV. Polling too frequently can make it difficult for users to diagnose query performance issues when their quickly rolls out of view.