SQL Monitor - Long Running Query Alert.

IanKeogh · December 16, 2022 2:12PM

SQL monitor, the alert for long running queries. i am trying to exclude jobs or queries that contain the following keywords. I separate them using | but that does not seems to work. And i know very little about regex.

So obviously the | separator is not working for me, could someone tell me the correct syntax please?

JOBS
UpdateStats
ReIndex

QUERY KEYWORDS
Index
Statistics

Below is what I have.

Image: https://us.v-cdn.net/6029854/uploads/editor/3b/hfbehr5etj3f.png

ThomasBE · December 21, 2022 2:34PM

You have to use 'ALTER INDEX' instead of 'INDEX'.
Mine is configured like:

Image: https://us.v-cdn.net/6029854/uploads/editor/59/01a2b0jvc9ky.png

Tom_C · December 19, 2022 11:53AM

Hi Ian,

Sorry this doesn't look to be working for you.

I would suggest putting these on separate lines and seeing if this makes any difference rather than using the | alternation.

Please let us know if this still doesn't look to be working as desired.

If you haven't already seen from the help window in the UI, here are some helpful links on RegEx:
https://learn.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference

https://regexlib.com/CheatSheet.aspx

IanKeogh · December 21, 2022 3:04PM

Thank you, I have made that change. I believe that should do the trick.

marclen · December 21, 2022 3:11PM

ThomasBE said:

You have to use 'ALTER INDEX' instead of 'INDEX'.
Mine is configured like:

Thank you, i searched for that

SEarle86 · December 29, 2022 10:00AM

FWIW, I have this in place which seems to be working well:

^BACKUP DATABASE

^BACKUP LOG

^RESTORE DATABASE

^RESTORE LOG

DBCC CHECKDB

SQL Monitor - Long Running Query Alert.

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk