Redgate Monitor set up for optimal performance  Redgate Monitor set up for optimal performance 

Redgate Monitor set up for optimal performance 

When getting started with Redgate Monitor, this article lists the setup recommendations for optimal performance.

1. Ensure adequate hardware is provisioned for hosting Redgate Monitor components (Base Monitor, Web Server, redgate Monitor Database). Check Hardware and Performance Guidelines for details.  

2. When monitoring more than 50 servers, we recommend hosting each Redgate Monitor component on a dedicated machine. 

3. Ensure there's a high speed network between the three components. 

4. Use multiple Base Monitors with each Base Monitor located as close as possible to the SQL Servers.  

5. Use the latest version of SQL Server for the Redgate Monitor Database. 

6. Review the Performance setting under Configuration > Data Settings > Performance. Check the sub section SQL Server Performance Recommendations for details. 

7. Review the Data Retention under Configuration > Data Settings > Data Retention. Check Setting Redgate Monitor data retention policy for details. 

8. For hosting large SQL Agent Job history, check Improving performance of SQL Agent job history sampling.

Related articles:

Getting started with Redgate Monitor

Configuring Metrics and Alerts in SQL Monitor