SQL Monitor - Long Running Query Alert.

• 

  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

   

  Tom_C December 19, 2022 11:53

  - 0 +
• 
  You have to use 'ALTER INDEX' instead of 'INDEX'. 
  Mine is configured like:
  
  

  ThomasBE December 21, 2022 14:34

  - 0 +
• 
  Thank you, I have made that change. I believe that should do the trick.

  IanKeogh December 21, 2022 15:04

  - 0 +
• 

  ThomasBE said:

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

  
  Thank you, i searched for that
  

  marclen December 21, 2022 15:11

  - 0 +
• 
  FWIW, I have this in place which seems to be working well:
  
  

  ^BACKUP DATABASE

  ^BACKUP LOG

  ^RESTORE DATABASE

  ^RESTORE LOG

  DBCC CHECKDB

  SEarle86 December 29, 2022 10:00

  - 0 +

Add comment

Please sign in to leave a comment.