Splunk AppDynamics

Database Health Rule for slow running query

Neeraj_Bhatnaga
New Member

Hello, we are working on setting some Health rules in AppDynamics to monitor slow-running queries in the Database. After going through the documentation on the website, we configured a health rule as seen below. Our problem with this is that there is a 'Group Replication module' (screenshot below) always running on the db side that is needed but causing constant violations.

image.png

image.png

Is there a way of adding an exception to queries so that similar items in the database do not trigger the violations? Is there another way you can suggest we move forward with this that will give us a more accurate result?

Labels (1)
0 Karma

Morelz
Motivator

Hi Neeraj

That metric is an overall global metric for all queries that gives you what it states. Time spent doing Executions for all queries in the Database.

What I would suggest is to speak to the DBA, and have them create you a custom query which you can run under custom metrics foreach DB, which can possibly exclude this specific query to give you a value that you can use in the health rule.

Ciao

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...