In SQL Monitor, I want to...

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) message_type_name, conversation_handle, cast(message_body AS XML) as message_body from [SqlQueryNotificationService-07e6439b-8276-45aa-963f-bed011b3ef2f]), TIMEOUT @p2

123 votes
Vote
Sign in
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Adrian Champ shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...
  • Rasmus Bielidt commented  ·   ·  Flag as inappropriate

    @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  ·   ·  Flag as inappropriate

    You can ignore known queries by adding --RedgateIgnore to the top of it. Is that sufficient for most cases?

  • David S commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

Feedback and Knowledge Base