Load Balancing Polling Engines

Question

Hey guys, I'm following up on the load balancing question that came from the latest Solarwinds lab.We should be able to provide a percentage for every node based on node + interface count, this is only looking to calculate the polling rate. The query is not finished, but gives a good starting point, the info provided by the query will show the total number of interfaces per node. I know that the numbers will vary depending on implementation, and there are other factors to consider.

Does anyone know the calculation used by Solarwinds to provide the utilization percent ? That would come in handy for this.

Hoping that this becomes a collaborative script.

---------------- Polling Engine Information ----------------

Select Engines.ServerName,EngineProperties.EngineID,EngineProperties.PropertyName,

EngineProperties.PropertyType,EngineProperties.PropertyValue,engines.Elements, Engines.Interfaces

From EngineProperties

INNER Join Engines

ON EngineProperties.EngineID = engines.EngineID

Where PropertyName = 'ORION.Standard.Polling'

-------- Node to Interface Count --------

SELECT Nodes.EngineID,Nodes.Caption,

--Interfaces.InterfaceName,

COUNT (*) AS NumberOfInterfaces

From Nodes

INNER JOIN Interfaces

ON Nodes.NodeID = Interfaces.NodeID

Where Nodes.UnManaged = '0'

Group by Nodes.EngineID,Nodes.Caption

Order by Nodes.EngineID

Thanks,

David

reidkell · Answer

Great post. I wish I would have come across this *before* I created basically the same queries myself. Below is the query I use to log poller data to an internal SQL database every night. Over time it can come in very handy, and enables me to create my own custom alerts for Polling Rate thresholds.

SELECT

ep.EngineID AS PollerID

, e.ServerName AS PollerServer

, e.IP AS PollerIP

, e.ServerType AS PollerServerType

, e.Elements AS TotalElements

, e.Interfaces AS InterfaceElements

, s1.NodeCount AS NetworkNodeElements

, ep.PropertyValue AS PollingRate

, s2.HardwareHealthPollingRate

, s3.TotalJobWeight

From EngineProperties ep

JOIN Engines e

ON ep.EngineID = e.EngineID

LEFT JOIN (SELECT EngineID, Count(NodeID) AS NodeCount FROM NodesData GROUP BY EngineID) s1

ON e.EngineID = s1.EngineID

LEFT JOIN (SELECT EngineID, PropertyValue AS HardwareHealthPollingRate FROM EngineProperties WHERE PropertyName = 'HardwareHealth.Polling') s2

ON e.EngineID = s2.EngineID

LEFT JOIN (SELECT EngineID, PropertyValue AS TotalJobWeight FROM EngineProperties WHERE PropertyName = 'Total Job Weight') s3

ON e.EngineID = s3.EngineID

WHERE ep.PropertyName = 'ORION.Standard.Polling'