Cleared Alerts are No Longer Visible

SQL Server performance monitoring and alerting

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

Cleared Alerts are No Longer Visible

Postby dboy360 » Fri Aug 24, 2012 12:46 pm

Good Morning,

We've been having a problem since SQL Monitor 3.0 (at least) where after we clear an alert, it's no longer visible. By that I mean, if we change the filter to show cleared alerts, it doesn't display all of the cleared alerts.

We're currently working through an issue with a vendor where we have multiple deadlocks for instance. Overnight, there may be several hundred that occur. After reviewing for patterns and such, we mark them as cleared. The problem occurs if we want to get a look at them again, and we change the filter to show cleared events, only a small subset of alerts are displayed.

Am I missing something? I figured I'd start by asking here before entering a support ticket.
Daniel Frederick II
Database Developer/Analyst
Four Seasons Produce, Inc
Email: danf@fsproduce.com
dboy360
 
Posts: 2
Joined: Fri Aug 24, 2012 12:37 pm
Location: Ephrata Pa

Postby priyasinha » Fri Aug 24, 2012 1:45 pm

Hello,

What is your purge policy?

Also, could you email screen shot at priya.sinha@red-gate.com?

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Postby dboy360 » Fri Aug 24, 2012 1:53 pm

Thanks for your response Priya.

I just sent a screen shot of our purge configuration to the email in your post. Did you want a screen shot of the alerts?
Daniel Frederick II
Database Developer/Analyst
Four Seasons Produce, Inc
Email: danf@fsproduce.com
dboy360
 
Posts: 2
Joined: Fri Aug 24, 2012 12:37 pm
Location: Ephrata Pa

Postby priyasinha » Fri Aug 24, 2012 2:37 pm

Thanks Daniel. Yes, I have received your email and replied you back. Can we please have screen shot of the alert inbox please with filters selected.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests