Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Server & Application Monitor (SAM) > Show how many components SAM is actually polling

Show how many components SAM is actually polling

Table of contents

Updated January 18, 2017

Overview

Here is a SQL query that you can run to show how many components are being polled per polling engine. This value can be (and typically is) higher than the licensed component count that is visible in the Web UI.

Environment

All SAM versions

Steps

  1. Log onto the Orion Server.
  2. Open Database Manager.
  3. Run the following query. Replace the 'X' in the query with the ID of each engine (can be found on the AllEngines or Engines table):
    SELECT Count(ccs.ApplicationID) Component_Count, e.EngineID FROM [dbo].[APM_CurrentComponentStatus] ccs
    JOIN [APM_Applications] ap on ccs.ApplicationID = ap.ID
    JOIN [Nodes] node on ap.NodeID = node.NodeID
    JOIN [Engines] e on node.EngineID = e.EngineID
    GROUP BY  e.EngineID
    ORDER BY Component_Count DESC

 

 

Additionally, they can run a similar query to the following to determine if there are a large number of components from a single monitor type (IE: AppInsight monitors)

SELECT Count(*) AS 'num'
  FROM [APM_CurrentComponentStatus]
WHERE ApplicationID in (select ID from [dbo].[APM_Application]
WHERE Name like '%iis%')
ORDER BY num desc;

 

 

Additionally, they can run the following to determine what AppID's are polling a large number of components

SELECT ccs.ApplicationID, ap.Name, Count(ccs.ApplicationID) Component_Count, node.Caption, e.EngineID FROM [dbo].[APM_CurrentComponentStatus] ccs
JOIN [APM_Applications] ap on ccs.ApplicationID = ap.ID
JOIN [Nodes] node on ap.NodeID = node.NodeID
JOIN [Engines] e on node.EngineID = e.EngineID
GROUP BY ap.Name, ccs.ApplicationID, node.Caption, e.EngineID
ORDER BY Component_Count DESC

 

 

 

 

Last modified
11:23, 11 Aug 2017

Tags

Classifications

Public