Red Gate forums :: View topic - Read only databases
Return to www.red-gate.com RSS Feed Available

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

Read only databases

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



Joined: 09 Jun 2014
Posts: 2

PostPosted: Mon Jun 09, 2014 4:32 am    Post subject: Read only databases Reply with quote

Hello!

How to disable database metrics for read-only databases? We have > 100 read-only databases and metrics use space in SQLMonitor DB.
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 328
Location: Cambridge, UK

PostPosted: Tue Jun 10, 2014 10:05 am    Post subject: Reply with quote

You can disable the database level alerts in the Alert Inbox. Simply select the entity in the tree on the left hand side of the Alert Inbox and then edit the alerts (the list will change to show the alerts that can be edited at each level).

Unfortunately, it is not possible to manually disable collections for specific databases though.

Are you seeing a specific problem?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
Olegon



Joined: 09 Jun 2014
Posts: 2

PostPosted: Tue Jun 10, 2014 11:11 am    Post subject: Reply with quote

Thanks, I know about alerts.
I don't need collections for this database because it takes space.
Eg, SQL Monitor works since 3 April 2014. Table data.Cluster_SqlServer_Database_Performance_UnstableSamples has about 58 000 000 records of which 48 000 000 records related to readonly databases for one server. And so on for tables Cluster_SqlServer_Database_Perfomance_... And imagine that we have few servers with about 100 readonly databases.
I want reduce RedGateMonitor database size but I dont want purge data for normal databases. So if I cant do this by in SQL Monitor I will have to do with handmade purge Smile
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