Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
09-11-2017 02:11 PM
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.
09-13-2017 12:18 AM
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;
07-18-2018 10:55 AM
Is it possable to get the total number of metrics/minute the Controller is collecting per application ?
07-18-2018 01:25 PM
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;
07-18-2018 02:00 PM
09-18-2018 08:15 AM
Is it possible to get metrics per minute by tenant on the Controller?
04-07-2022 02:51 PM
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 |
---|---|
4 | |
3 | |
3 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form