cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Controller (SaaS, On Premises)

View total number of metrics/minute the Controller is collecting

SOLVED
Jon.Faldmo
Maker

View total number of metrics/minute the Controller is collecting

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?

By replying you agree to the Terms and Conditions of the AppDynamics Community.
View total number of metrics/minute the Controller is collecting
5 REPLIES 5
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.
Tim.Ellsworth
Creator

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

 

Jon.Faldmo
Maker

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;

Tim.Ellsworth
Creator

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

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