SQL Monitor - Long Running Query Alert.

IanKeogh

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.

ThomasBE

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

Tom_C

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

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

marclen

ThomasBE said:

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

Thank you, i searched for that

SEarle86

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

^BACKUP DATABASE

^BACKUP LOG

^RESTORE DATABASE

^RESTORE LOG

DBCC CHECKDB