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.
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?
Hi Jonathan,
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;
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;
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!
User | Count |
---|---|
9 | |
4 | |
2 | |
2 | |
1 | |
1 |
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form