RedGateMonitor Database Performance
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?
0 · Share on Twitter