topic Re: View total number of metrics/minute the Controller is collecting in Splunk AppDynamics

View total number of metrics/minute the Controller is collecting

CommunityUser — Mon, 11 Sep 2017 21:11:55 GMT

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?

Re: View total number of metrics/minute the Controller is collecting

Atyuha_Pal — Wed, 13 Sep 2017 07:18:48 GMT

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;

Re: View total number of metrics/minute the Controller is collecting

tellsworth_splu — Wed, 18 Jul 2018 17:55:16 GMT

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

Re: View total number of metrics/minute the Controller is collecting

CommunityUser — Wed, 18 Jul 2018 20:25:36 GMT

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;

Re: View total number of metrics/minute the Controller is collecting

tellsworth_splu — Wed, 18 Jul 2018 21:00:21 GMT

Great thanks looks good. Will have to run when we have load.

Re: View total number of metrics/minute the Controller is collecting

CommunityUser — Tue, 18 Sep 2018 15:15:16 GMT

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

Re: View total number of metrics/minute the Controller is collecting

ICG_AppD_Leads — Thu, 07 Apr 2022 21:51:52 GMT

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!