RedGateMonitor Database Performance
rpriesing
Posts: 12 Bronze 1
Has there been any work done on improving the performance of the RedGateMonitor Database? We are running on Windows server 2012, SQL 2014 and have 81 servers being monitored, the database has grown to 600GB with 5 tables being the bulk of that space. Regular Index Maintenance takes over a day to complete for the whole database. Anyone do any partitioning of the larger tables (Cluster_SqlServer_Database_Performance_UnstableSamples, Cluster_Machine_Process_UnstableSamples, Cluster_SqlServer_Database_Storage_UnstableSamples, Cluster_SqlServer_Database_File_UnstableSamples, Cluster_SqlServer_TopQueries_UnstableSamples) to help with performance and data purging? Any other tricks to speed up access and overall performance?
Comments
You could try purging the history, by following the documentation link below:
Documentation link
We also have a scheduling tool, which I can email to you via a support ticket, but can also be obtained via emailing support@red-gate.com
With the amount of servers being monitored you may wish to consider how much history is kept.
Many Thanks
Wendy Mitchell
Product Support Engineer
I do have a similar issue, and it's just 4 servers. However, I found that for SQL maintenance itself, including RedGate monitor database, Ola Hallengren solution is the best. Look for it online.
It's free. But really powerful too. It skips tables based on amount of pages and fragmentation. That can speed up the maintenance job a bit.