Red Gate forums :: View topic - Disable monitoring for a specific database
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

Disable monitoring for a specific database

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



Joined: 13 Aug 2013
Posts: 2

PostPosted: Tue Aug 13, 2013 12:53 pm    Post subject: Disable monitoring for a specific database Reply with quote

Hello,

I have been receiving 30-50+ deadlock alerts a day due to a known issue with a SAP Business Objects database crawl that triggers deadlocks. From my initial research there doesn't seem to be a lot of simple methods around stopping the deadlocks, short of disabling the search crawl that triggers them in the first place. However, that would also essentially break the search function on the respective Business Objects site -- which isn't a viable option right now.

That said, my initial thought is that I'd like to see if it's possible to configure SQL Mon to simply ignore deadlock monitoring for that particular database. I usually wouldn't consider this an option, but this database isn't one I am particularlly worried about on that server, so I'd rather it not flood my alerts and cause me to miss something more important.

I am currently on version 3.3 of SQL Mon, and the databases are SQL 2008 R2.

Thanks in advance for any possible help,
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Tue Aug 13, 2013 1:18 pm    Post subject: Reply with quote

Hi,

Unfortunately, this is not currently supported. I would suggesting raising/ voting for this feature on http://sqlmonitor.uservoice.com/. This helps us to prioritise next set work which we will be undertaking.

Thanks,
Priya
Back to top
View user's profile Send private message
PaulyW



Joined: 28 Aug 2013
Posts: 2

PostPosted: Wed Aug 28, 2013 9:59 am    Post subject: Re: Reply with quote

priyasinha wrote:
Hi,

Unfortunately, this is not currently supported. I would suggesting raising/ voting for this feature on http://sqlmonitor.uservoice.com/. This helps us to prioritise next set work which we will be undertaking.

Thanks,
Priya


That's already been done and was raised over a year before the original post:

http://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/3008699-disable-deadlock-alert-emails-at-the-database-leve

It has 22 votes but still hasn't made it into a development schedule yet.

Maybe you could expand it to disable *any* alert at a database level?
Back to top
View user's profile Send private message
PaulyW



Joined: 28 Aug 2013
Posts: 2

PostPosted: Mon Oct 07, 2013 10:40 am    Post subject: Reply with quote

Are there any plans to include this in the next release? It was requested over a year ago on the suggestions site.

Would be a huge help for us all if you could include it.
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