Read only databases

SQL Server performance monitoring and alerting

Moderators: Colin Millerchip, priyasinha, Adam, chriskelly

Read only databases

Postby Olegon » Mon Jun 09, 2014 4: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: 2
Joined: Mon Jun 09, 2014 4:22 am

Postby chriskelly » Tue Jun 10, 2014 10: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?
Chris Kelly
Technical Support Engineer
Posts: 330
Joined: Mon Apr 19, 2010 1:44 pm
Location: Cambridge, UK

Postby Olegon » Tue Jun 10, 2014 11: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: 2
Joined: Mon Jun 09, 2014 4:22 am

Return to SQL Monitor 4

Who is online

Users browsing this forum: No registered users and 0 guests