Exclude queries from top 10 queries
I would like to be able to exclude specific queries from Top 10 Queries. We use SQLQueryNotificationService which means our top 10 queries based on duration are always showing these queries as they have a waitfor. I would like the ability to exclude items from the top 10 queries.
Typical query I would like to able to exclude:
WAITFOR(RECEIVE TOP (1) messagetypename, conversationhandle, cast(messagebody AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2
-
Rasmus Bielidt commented
@Anonym - that would work when you have control over the query text. If it comes from a vendor you may not be able to change it easily. In that case it would be easier to have a repository of query hashes to ignore (like Solarwinds DPA has).
-
Anonymous commented
You can ignore known queries by adding --RedgateIgnore to the top of it. Is that sufficient for most cases?
-
Ian Pain commented
Have the same issue, can't wait for an update that sorts this problem
-
David S commented
I have the same issue. I would also like this to exclude from the summary reports and not just in the overview as having a summary where only 1 query being highlighted is useful is pretty pointless.
-
Konst commented
Yes. I have the same problem with Top query report by duration. WAITFOR (RECEIVE ...) is a noise for me and prevents me from identifying really long queries.