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.
I'm trying to use AppDynamics to monitor an application session counts based on a specific program that the application is running.
I also need this to monitor the resource utilization of the database when this occurs.
I would like it if I could get results every minute, then for it to report immediately when a specific percentage/count of resources have been reached, and then report every 30 minutes later if the occurrence is still happening.
This will be somewhat customized since I'm pulling a specific program. I haven't found a good document on how to implement customized SQL and reporting the results. I'm also not sure if session counts for the program could/should be pulled off the application-vs-the database.
Here is an idea I want to monitor and at the count level I want it to report.
select username, osuser, machine, count(*)
where program like '%w3wp%'
group by username, osuser, machine
having count(*) > 100;
select resource_name, current_utilization, max_utilization, limit_value
where resource_name in ('sessions', 'processes')
and current_utilization > 530;
Hi. You can do this with the database agent's custom metric capability:
You would then leverage health rules and policies to alert on issues: