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.
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?
Solved! Go to Solution.
Please refer to the below link to get the detail
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;
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;