End User Monitoring (EUM)

cancel
Showing results for 
Search instead for 
Did you mean: 

Running customized SQL to create an alert and weekly statistics

Highlighted
New Member

Running customized SQL to create an alert and weekly statistics

Hi,

 

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(*)

from v$session

where program like '%w3wp%'

group by username, osuser, machine

having count(*) > 100;

 

select resource_name, current_utilization, max_utilization, limit_value

from v$resource_limit

where resource_name in ('sessions', 'processes')

and current_utilization > 530;

Running customized SQL to create an alert and weekly statistics
1 REPLY 1
AppDynamics Team

Re: Running customized SQL to create an alert and weekly statistics

Hi. You can do this with the database agent's custom metric capability:

 

https://docs.appdynamics.com/display/PROD/Configuring+Custom+Metrics

 

You would then leverage health rules and policies to alert on issues:

 

https://docs.appdynamics.com/display/PRO45/Alert+and+Respond