Red Gate forums :: View topic - Clear 100K alerts
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  | Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Clear 100K alerts

 Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
fifthrace



Joined: 08 Jun 2012
Posts: 12
Location: Indianapolis, IN
PostPosted: Mon Mar 18, 2013 1:38 pm    Post subject: Clear 100K alerts Reply with quote
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
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 487
PostPosted: Tue Mar 19, 2013 10:08 am    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
fifthrace



Joined: 08 Jun 2012
Posts: 12
Location: Indianapolis, IN
PostPosted: Tue Mar 19, 2013 12:37 pm    Post subject: Thanks Reply with quote
Awesome, I never saw that option.

Thanks a ton,

Robbie
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group