Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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

Run the following SQL query 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 in to the Orion Server.
  2. Open Database Manager.
  3. Run the following query.
    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, you 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, you 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
10:51, 14 Sep 2017

Tags

Classifications

Public