cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

View total number of metrics/minute the Controller is collecting

Jon.Faldmo
Maker

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?

6 REPLIES 6

Atyuha.Pal
AppDynamics Team

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;

 



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.

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

 

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;

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

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

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!