Red Gate forums :: View topic - Suspended Monitoring & Database Filtering
Return to RSS Feed Available

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

Suspended Monitoring & Database Filtering

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

Joined: 29 Dec 2011
Posts: 1

PostPosted: Thu Dec 29, 2011 1:29 am    Post subject: Suspended Monitoring & Database Filtering Reply with quote


We're trialing SQL Monitor 2.3 in our environment and I'm having some issues with suspended monitoring. I also have some questions about DB filtering.

We have a few solutions where a database will be backed up from one environment/server, and then copied/restored to another as a means of bulk data transfer over some very slow links.

Each day the DB will be recreated, backed up, copied and restored again. SQL Monitor loses it's permissions each time this happens, and suspends monitoring for all databases.

Now, I know the 'simple' answer is "just add the permissions before you backup", but we're in strict RBAC security contexts, and the security context between the environments is different. It's not practical to essentially embed SQL Monitor roles into our applications/solutions. We're also not comfortable integrating a monitoring tool that closely.

We're also not allowed to run SQL Monitor under an 'sa' account. (Again, highly secure environment).

Ideally, if there was a way to disable monitoring for certain databases, I think this would solve our issue. Our of 20-30 db's, there are only 5 that really need constant monitoring, others are archives, or temp data stores.

It's quite annoying that SQL Monitor needs access to all of these databases, even though we have no interest in monitoring them.
Back to top
View user's profile Send private message
eddie davis

Joined: 14 Jun 2006
Posts: 941
Location: Red Gate Software

PostPosted: Fri Dec 30, 2011 12:47 pm    Post subject: Reply with quote

Thank you for your e-mail that my Sales colleague, Jenna Wass, passed onto the Product Support.

SQL Monitor has been designed to monitor every database, this is the purpose of tool to monitor your SQL Servers.

Whilst you can suspend monitoring for database maintenance reasons -

Or for certain alerts, not all of the alerts, you can choose not to alert for specific databases and through the Alerts Overview filter out databases that you wish not to see alerts generated for them. There is no option to suspend or stop monitoring specific databases.

Therefore I have submitted Feature Request SRP-5652, to request the ability to suspend monitoring for specific databases. I cannot guarantee that this request will be successful or if approval is given what future version of SQL Monitor it will appear in.

I will be maintain what our Bug Tracking / Feature Request system calls a 'Watch', which means I will be updated on the actions taken by the SQL Monitor Development Team.

I believe that you have been in contact with your Red Gate Sales Representative and a support call F0055789 was generated for you.

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
Back to top
View user's profile Send private message Send e-mail
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