How can we help you today? How can we help you today?

How do I exclude queries with SQL Process

I want to exclude the process - Spotlight Diagnostic Server XEventsReader (Monitoring)
If a regex is required, do you have an example I may use or create the exclusion code for me?

Thanks,
GaryJ
GaryJ
0

Comments

2 comments

Sort by
  • Alex B
    Hi @GaryJ,

    Where are you looking to exclude these queries? 

    You can't exclude specific queries from e.g. the Top X queries section or the SQL Users processes section on the Server Overview.

    The alert configurations for e.g. Long-running queries has a box to add regular expressions to exclude by SQL Process name and it depends on the specific name shown in the long running query - if it is as you wrote "Spotlight Diagnostic Server XEventsReader (Monitoring)" exactly then a regex would be "Spotlight Diagnostic Server XEventsReader \(Monitoring\)" (though there are other regex can match it):



    If you mean in a different place you are looking to have them excluded please let me know!

    Kind regards,
    Alex
    ​
    Alex B
    0
  • GaryJ
    Yes, this specific text is what I wanted to exclude. It seems to be working.
    thanks
    GaryJ
    0

Add comment

Please sign in to leave a comment.