I was looking at the distributed polling feature as we have a geographically distributed network and polling slow devices from half way across the globe takes a long time. It turns out that putting a poller closer to the device doesn’t actually help. The SNMP polling times go down a bit, but the SQL times go up a lot because there are hundreds of SQL queries that get run for every polled device. This can easily add another 1-2 minutes to your polls depending on how many metrics are being polled. So, it seems to me that the distributed feature only works if the poller is still reasonably close to the database, otherwise the latency per query eats up any gains you might have from reducing the SNMP latency.
Are there plans to try to reduce the number of queries a poller makes to make geographically distributed polling less latency sensitive?
Cheers
Milton