Read only databases

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Read only databases

Postby Olegon » Mon Jun 09, 2014 3:32 am


How to disable database metrics for read-only databases? We have > 100 read-only databases and metrics use space in SQLMonitor DB.
Posts: 4
Joined: Mon Jun 09, 2014 3:22 am

Postby chriskelly » Tue Jun 10, 2014 9:05 am

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?
Posts: 373
Joined: Mon Apr 19, 2010 12:44 pm
Location: Cambridge, UK

Postby Olegon » Tue Jun 10, 2014 10:11 am

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 :)
Posts: 4
Joined: Mon Jun 09, 2014 3:22 am

Return to SQL Monitor Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests