Need to get cpu and memory usage for Component level. Which table should I query or look for in orion APM database

anooppandey3

I need to get cpu and memory usage on component level. Which table should I query or look for in orion apm database

Find more posts tagged with

solarwinds reports

apm_component_details_view

component status

solarwinds sam

Accepted answers

m-milligan

Look in Orion.APM.CurrentStatistics, specifically the ComponentPercentCPU and ComponentPercentMemory columns. If you're working in SWQL, you can drill down from an Application as Application.Component.CurrentStatistics.ComponentPercentCPU and Application.Component.CurrentStatistics.ComponentPercentMemory.

Seashore

Hi @anooppandey3

The join operations required are in several steps and several tables. As detailed data get aggregated into hourly, and into daily, the data is in several tables.

To only get the detailed info you do something like this:

SELECT
	C.Name
	,CSD.TimeStamp
	,PED.PercentCPU
	,PED.PercentMemory
FROM APM_Component AS C
INNER JOIN APM_ComponentStatus_Detail AS CSD ON C.ID=CSD.ComponentID
INNER JOIN APM_ProcessEvidence_Detail AS PED ON CSD.ID=PED.ComponentStatusID
WHERE 
	C.id=62951 --ID of your component
	AND CSD.TimeStamp>Getdate()-2 --How many days back you want data
GO

To get data back even further in time there are a few more tables to look at but Orion has SQL Views created just for that, using that view the query can look like this:

SELECT
	C.Name
	,PEC.TimeStamp
	,PEC.AvgPercentCPU
	,PEC.AvgPercentMemory
FROM APM_Component AS C
INNER JOIN APM_ProcessEvidenceChart AS PEC ON C.ID=PEC.ComponentID
WHERE 
	C.id=62951
	AND PEC.TimeStamp>Getdate()-2

Hope above gets you on the right track. Mind that above examples is for SQL code and @m-milligan showed you table names for a SWQL query. the names are different.

All comments

m-milligan

anooppandey3

Thanks for the response. I am looking today's complete data for CPU and Memory usage on component level. I think as per your answer it is giving current time data only.

Seashore

Hi @anooppandey3

The join operations required are in several steps and several tables. As detailed data get aggregated into hourly, and into daily, the data is in several tables.

To only get the detailed info you do something like this:

SELECT
	C.Name
	,CSD.TimeStamp
	,PED.PercentCPU
	,PED.PercentMemory
FROM APM_Component AS C
INNER JOIN APM_ComponentStatus_Detail AS CSD ON C.ID=CSD.ComponentID
INNER JOIN APM_ProcessEvidence_Detail AS PED ON CSD.ID=PED.ComponentStatusID
WHERE 
	C.id=62951 --ID of your component
	AND CSD.TimeStamp>Getdate()-2 --How many days back you want data
GO

To get data back even further in time there are a few more tables to look at but Orion has SQL Views created just for that, using that view the query can look like this:

SELECT
	C.Name
	,PEC.TimeStamp
	,PEC.AvgPercentCPU
	,PEC.AvgPercentMemory
FROM APM_Component AS C
INNER JOIN APM_ProcessEvidenceChart AS PEC ON C.ID=PEC.ComponentID
WHERE 
	C.id=62951
	AND PEC.TimeStamp>Getdate()-2

Hope above gets you on the right track. Mind that above examples is for SQL code and @m-milligan showed you table names for a SWQL query. the names are different.

anooppandey3

Hi @Seashore,

Thanks for response. Could you please let me the unit type of memory and how can I get free space of memory. Please specify the unit with calculation of free space of memory

Seashore

In my example it is percentage used.

In the view [dbo].[CPULoad] you have "PercentMemoryUsed" and also AVGMemoryUsed. With that you can count how much is free.

anooppandey3

Is this work for component level as well? how can I get total of IO Operation at component level?

Seashore

I suggest you take out "node free memory" as a separate query. It will be to complicated to have in the same query.

To get IOPS just add that columne in the output, like this:

SELECT
C.Name
,PEC.TimeStamp
,PEC.AvgPercentCPU
,PEC.AvgPercentMemory
,PEC.AvgIOReadOperationsPerSec
FROM APM_Component AS C
INNER JOIN APM_ProcessEvidenceChart AS PEC ON C.ID=PEC.ComponentID
INNER JOIN APM_Application A ON C.ApplicationID=A.ID

WHERE
C.id=62951
AND PEC.TimeStamp>Getdate()-2

There are several mode columns available. Check the view in SQL...