Clear 100K alerts

SQL Server performance monitoring and alerting

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

Clear 100K alerts

Postby fifthrace » Mon Mar 18, 2013 1:38 pm

I have an issue where over 155K alerts were fired off for a "SQL Server error log entry". This was all due to a service account's password expiring on one of our application servers. Don't get me started....

Anyway, I really don't want to select All -> Clear 1500 times.

Is there a good way to clear a bunch of the same alert quickly?

I'm on SQL Monitor 3.2.1.231.

Thanks for any guidance that can be given here.

Robbie
fifthrace
 
Posts: 12
Joined: Fri Jun 08, 2012 5:49 pm
Location: Indianapolis, IN

Postby priyasinha » Tue Mar 19, 2013 10:08 am

Hi Robbie,

Yes, please follow these steps:

1. Click on 'Select'.
2. You should get a green panel. Click on 'Select all alerts across all pages' link.
3. Click 'Cleared'.

This will clear all the alerts.

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

Thanks

Postby fifthrace » Tue Mar 19, 2013 12:37 pm

Awesome, I never saw that option.

Thanks a ton,

Robbie
fifthrace
 
Posts: 12
Joined: Fri Jun 08, 2012 5:49 pm
Location: Indianapolis, IN


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron