cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Automatically balance nodes against multiple polling engines.

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.

Labels (1)
Attachments
Comments

Part of your script appears to be missing.

good spot dfairles, I have updated the sql file. This has been running for a few months now with no real negative feedback. (Apart from the network team that look after asa as they can't put a subnet for snmp polling.)

Version history
Revision #:
1 of 1
Last update:
‎02-22-2016 07:08 AM
Updated by: