IPAM 4.6 - Monitor load per APE

stevenstadel

How can I tell what the load for IPAM is on each Additional Polling Engine? Is there a performance counter or process we can monitor?

We want to make sure that we are not overloading any particular polling engine.

/Orion/Admin/Details/Engines.aspx - Checked out the APE stats but can't determine the effect of IPAM on an APE

mesverrum

So far I haven't come across anything in the db specifically measuring the loads, but this custom SWQL report is what I've put together so far, obviously only works if you are running ipam 4.6.  Lists off all the engines that have subnets assigned to them, counts out the total number of subnets, how many of those subnets have scanning enabled, how many total addresses are being scanned and how many are showing as used.  Should at be able to give you a sense if there is a particular poller that is working more than the others.  Still haven't decided what the upper limits are but I can tell you I added about a million addresses to each of the pollers at my latest client and there was a fairly dramatic increase in the CPU loads.

SELECT g.Engines.ServerName, count(g.GroupId) as [TotalSubnets], en.EnabledScans, cnt.TotalAddresses, cnt.UsedAddresses

FROM IPAM.GroupNode g

left join (SELECT g.Engines.ServerName, count(GroupId) as [EnabledScans]

FROM IPAM.GroupNode g

where grouptype=8 and g.DisableAutoScanning=0

group by g.Engines.ServerName) en on en.servername=g.Engines.ServerName

left join (select g.Engines.ServerName, sum(g.TotalCount) as [TotalAddresses], sum(g.UsedCount) as [UsedAddresses]

FROM IPAM.GroupNode g

where grouptype=8

group by g.Engines.ServerName

) cnt on cnt.servername=g.engines.servername

where g.grouptype=8

group by g.Engines.ServerName, en.enabledScans, cnt.TotalAddresses, cnt.UsedAddresses

order by  g.Engines.ServerName