Splunk AppDynamics

View total number of metrics/minute the Controller is collecting

CommunityUser
Splunk Employee
Splunk Employee

The controller system requirements, specifically the "Controller Performance Profile Definitions"that should be used are based off of the "Maximum Metric Count/Minute." How do you view or calculate that in an existing installation?

Labels (3)
0 Karma
1 Solution

Atyuha_Pal
Contributor

Hi Jonathan,

Please refer to the below link to get the detail

https://vimeo.com/109489219

Also you can run the below query to determine how many metrics inserted per minute in controller DB.

mysql> select from_unixtime(ts_min*60), NOW(), count(distinct(node_id)), count(*) from metricdata_min where ts_min > (select max(ts_min) - 10 from metricdata_min) group by 1 order by 1;

View solution in original post

Atyuha_Pal
Contributor

Hi Jonathan,

Please refer to the below link to get the detail

https://vimeo.com/109489219

Also you can run the below query to determine how many metrics inserted per minute in controller DB.

mysql> select from_unixtime(ts_min*60), NOW(), count(distinct(node_id)), count(*) from metricdata_min where ts_min > (select max(ts_min) - 10 from metricdata_min) group by 1 order by 1;

ICG_AppD_Leads
Engager

Hello,

Where do I run these SQL queries? Do I have to actually log on COntroller's DB or can I run it from somewhere on UI? And do I need a certain permission?

Thanks!

0 Karma

tellsworth_splu
Explorer

Is it possable to get the total number of metrics/minute the Controller is collecting per application ?

0 Karma

CommunityUser
Splunk Employee
Splunk Employee

This query will give the you start time used in the query, the end time, application name, number of nodes per application, and number of metrics per application.

SELECT from_unixtime(ts_min*60), NOW(), a.name AS application_name, count(distinct(mm.node_id)), count(*) FROM metricdata_min AS mm, application AS a 

WHERE ts_min > (SELECT max(ts_min) - 2 FROM  metricdata_min) AND ts_min < (SELECT max(ts_min) FROM metricdata_min) AND a.id = mm.application_id GROUP BY application_name, 1 ORDER BY 1;

tellsworth_splu
Explorer
Great thanks looks good. Will have to run when we have load.
0 Karma

CommunityUser
Splunk Employee
Splunk Employee

Is it possible to get metrics per minute by tenant on the Controller?

0 Karma
Get Updates on the Splunk Community!

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL

Splunk AI Assistant for SPL | Key Use Cases to Unlock the Power of SPL  The Splunk AI Assistant for SPL ...

Buttercup Games: Further Dashboarding Techniques (Part 5)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Customers Increasingly Choose Splunk for Observability

For the second year in a row, Splunk was recognized as a Leader in the 2024 Gartner® Magic Quadrant™ for ...