Mail problem in v3.0 - custom alerts

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Mail problem in v3.0 - custom alerts

Postby mipe10 » Tue Mar 27, 2012 8:55 am

Hi,
I have created a number of custom metrics and alerts. Everything works fine except for one thing - mail.

In the previous version of sqlMonitor I had a defined default mail profile activated under e-mail settings. Some alerts use this profile to send mail while I on other alerts configured them not to use default mail profile by leaving it empty showing \"none\" as email notification under alert settings.

In v3.0 you cant set a custom alert to \"none\". So my question is how do you have a default email profile activated while at the same time you dont want to send mails on specific custom alerts?

Regards
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby Chris Spencer » Tue Mar 27, 2012 12:24 pm

Hi

I've looked into this and can see that we have a few issues in this area that will need fixing. I've raised a bug report (ref: SRP-6380).

For a workaround, I think you can specify an email address in the alert settings notification override section and it'll save as \"none\" anyway (that's a bug!). I tested this and didn't receive an alert email for that specific alert.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby mipe10 » Tue Mar 27, 2012 2:21 pm

Hi,
The workaround worked, thanks..

Regards
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby mipe10 » Tue Mar 27, 2012 2:37 pm

Hi,
I was a little bit to quick. Even though the mailoperator is set to none an email was sent.
mipe10
 
Posts: 46
Joined: Wed Nov 22, 2006 2:08 pm

Postby Chris Spencer » Tue Mar 27, 2012 3:17 pm

Hi

That's weird - I can't get the email override to work at all. Even overriding with the address I've set as default seems to prevent emails for specific alerts.

I'll continue investigating.

Thanks
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Mail problem in v3.0 - custom alerts

Postby joffwilliams » Tue Mar 27, 2012 4:13 pm

Glad to see this is a known bug. Discovered it this morning when working with an alert.

Chris, how does the bug-reporting and fixing process usually work? Should we expect to see a fix rolled out in an update to the software?
joffwilliams
 
Posts: 13
Joined: Tue Mar 27, 2012 4:10 pm
Location: Spokane, WA

Postby Chris Spencer » Tue Mar 27, 2012 4:52 pm

This issue would almost certainly be fixed in the next SQL Monitor release. Whether this release is an update to v3.0 or further down the line in v3.1 is not my decision unfortunately. I'll post here when I know more.

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Mail problem in v3.0 - custom alerts

Postby joffwilliams » Tue Mar 27, 2012 6:07 pm

Thanks, Chris.
joffwilliams
 
Posts: 13
Joined: Tue Mar 27, 2012 4:10 pm
Location: Spokane, WA

Postby Chris Spencer » Fri Mar 30, 2012 2:55 pm

Update: We're fixing this now and there's a good chance that a new build will be available next week.

Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge

Postby Chris Spencer » Tue Apr 03, 2012 10:14 am

A new build that fixes this issue can now be downloaded.
http://www.red-gate.com/products/dba/sq ... r/download

Regards
Chris
Chris Spencer
Test Engineer
Red Gate
Chris Spencer
 
Posts: 301
Joined: Tue Aug 29, 2006 9:09 am
Location: Red Gate - Cambridge


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests