jefff

That script is perfect, just a few minor modifications to make it run. I was digging around, trying to find where the default threshold values are stored, but not having much luck, probably because I'm not exactly sure how this all ties together. Is there a different table that holds the default values?

Thank you. I will give it a go and see what I can do with it. It will be a good baseline.

Thanks for the response. Yes, that is the correct term. Maybe I can explain a bit better what we are trying to gather. In the example, we want to change the "Page Reads/sec" threshold, which has a default value of lets say 150, which is inherited by all of the children objects as a default threshold value. Someone change…

So I'm still a bit confused on this one, but that was good information you provided. So on one of our environments we are showing When I follow the link and scroll down to "Top 10 Expensive Queries by CPU Time", assuming that this is what it is complaining about, there is nothing flagged in red. And as expected nothing…