Version 2

    To give a little back, here's a script that I developed.

    PROBLEM:

    We have multiple people adding nodes to additional pollers, and they don't choose the one with the least nodes currently being polled. This was leading to some bottlenecks in our environment with some of our pollers reaching over 95% polling rate and others down at 10%. I created the attached script that:

    • Calculates the cost of each node, (Number of volumes, interfaces and IPSLA operations on each node)
    • Balances these nodes out across the all the additional pollers based on cost.
    • Only nodes that are in maintenance mode get assigned to the main poller as it is working hard enough.

     

    Solution:

    Attached SQL script is run as an SQL server Agent T-SQL job weekly.