Read only databases

Olegon

Hello!

How to disable database metrics for read-only databases? We have > 100 read-only databases and metrics use space in SQLMonitor DB.

chriskelly

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?

Olegon

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