Comments
Sort by recent activity
I following your instructions for putting the exclusions on one line. The area in SQL Monitor where you place the exclusions only will hold so many characters before it wraps to the next line. THis does appear to be working though. Maybe the use of the | between each exclusion item resolves this. Thanks. / comments
I following your instructions for putting the exclusions on one line. The area in SQL Monitor where you place the exclusions only will hold so many characters before it wraps to the next line. TH...
OK. I was able to exclude the Database Mail queries by adding the sp_readrequest entry, so this does work for that. / comments
OK. I was able to exclude the Database Mail queries by adding the sp_readrequest entry, so this does work for that.
I added ^[Ww]omaster ?. I previously had \bWomaster\b. I'm still receiving alerts. This is the full SQL process fragment. Thanks.
SELECT "dbo"."Womaster"."WO #" FROM "dbo"."Womaster" ORDER BY "dbo"."Womaster"."Date Entered" DESC / comments
I added ^[Ww]omaster ?. I previously had \bWomaster\b. I'm still receiving alerts. This is the full SQL process fragment. Thanks.
SELECT "dbo"."Womaster"."WO #" FROM "dbo"."Womaster" ORDER BY "...
So far, I have the following in the exclusion list. I continue to receive alerts for the long queries involving Womaster.
Database Mail
Womaster|"Womaster"
\bWomaster\b
RESTORE VERIFYONLY
SQLBackup
DatabaseMail90
FROM "dbo"."Womaster"
sp_readrequest
SELECT "dbo"."Womaster"."
^[Ww]omaster ? / comments
So far, I have the following in the exclusion list. I continue to receive alerts for the long queries involving Womaster.
Database Mail
Womaster|"Womaster"
\bWomaster\b
RESTORE VERIFYONLY
SQLBacku...