cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

Within DPA, is it possible to filter out a specific query?

Jump to solution

I have a situation where one query (which I can do nothing about) is making it difficult to look at other queries running in the same database. I'd like DPA to ignore this query (until it gets fixed) and allow me to see what else is going on in my database easier.

Tags (2)
0 Kudos
1 Solution

On the SQL tab, where you see a list of hashes and named queries, click on

one. In the upper right corner of the resulting dialog, you should see a

checkbox labeled "Exclude this SQL from Performance-side Trend charts".

Check that, click OK, and it should vanish from most of your screens. This

feature was added as part of one of the 9.x versions, but I don't recall

which one. If you don't see the checkbox, you are probably running an old

version of DPA.

Mark Freeman

Database Administrator | Rogue Fitness

1080 Steelwood Road, Columbus, OH 43212

MFreeman@RogueFitness.com

On Wed, Oct 21, 2015 at 1:20 PM, cecilhawkins <

View solution in original post

0 Kudos
4 Replies
Level 17

‌yes, you can. you can remove it from the ignore list as well any time

0 Kudos

I guess I should have been more specific. Now that I know there is an ignore list, how do I go about putting my query in it?

0 Kudos

On the SQL tab, where you see a list of hashes and named queries, click on

one. In the upper right corner of the resulting dialog, you should see a

checkbox labeled "Exclude this SQL from Performance-side Trend charts".

Check that, click OK, and it should vanish from most of your screens. This

feature was added as part of one of the 9.x versions, but I don't recall

which one. If you don't see the checkbox, you are probably running an old

version of DPA.

Mark Freeman

Database Administrator | Rogue Fitness

1080 Steelwood Road, Columbus, OH 43212

MFreeman@RogueFitness.com

On Wed, Oct 21, 2015 at 1:20 PM, cecilhawkins <

View solution in original post

0 Kudos

with screenshots for Mark Freeman's instructions

Database Performance Analyzer 9.1 Release Candidate is available now!!!!