Disable monitoring for a specific database

SQL Server performance monitoring and alerting

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

Disable monitoring for a specific database

Postby pharrell » Tue Aug 13, 2013 12:53 pm

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,
pharrell
 
Posts: 2
Joined: Tue Aug 13, 2013 12:45 pm

Postby priyasinha » Tue Aug 13, 2013 1:18 pm

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
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm

Re:

Postby PaulyW » Wed Aug 28, 2013 9:59 am

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/ ... abase-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?
PaulyW
 
Posts: 2
Joined: Wed Aug 28, 2013 9:53 am

Postby PaulyW » Mon Oct 07, 2013 10:40 am

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.
PaulyW
 
Posts: 2
Joined: Wed Aug 28, 2013 9:53 am


Return to SQL Monitor 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron