RedGateMonitor Database Performance

rpriesingrpriesing Posts: 12 Bronze 1
edited June 1, 2015 1:43PM in SQL Monitor Previous Versions
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

  • Hi Russ

    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 [email protected]

    With the amount of servers being monitored you may wish to consider how much history is kept.

    Many Thanks
    Wendy Mitchell
    Product Support Engineer
  • rpriesing wrote:
    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?

    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.
Sign In or Register to comment.