Adding Amazon RDS SQL Server

Amazon RDS provides cloud-managed SQL Server instances. Each instance will run on its own isolated database environment operating within Amazon Web Services (AWS). When dealing with a cloud server, it's not possible to retrieve metrics in the same way as on-premise servers, meaning that Redgate Monitor relies on the AWS API to retrieve some metrics.

Further metrics are only available when the Enhanced Monitoring feature is enabled for the Amazon RDS instance. Learn how to enable AWS Enhanced MonitoringThis page explains how to add an Amazon RDS SQL Server to Redgate Monitor and supply its credentials to Redgate Monitor.

For details of the metrics and alerts available for Amazon RDS SQL Servers, which of these are available only through the AWS API, and which also require the enhanced monitoring feature to be enabled for the RDS instance, please see: SQL Server on Amazon RDS metrics and alerts.

Ensure that the Amazon RDS SQL Server is reachable by the machine running the Base Monitor. You can make a connectivity test by trying to access the Amazon RDS SQL Server from the Base Monitor machine through SSMS (AWS documentation). Check the different ways you can modify Amazon RDS' security group in this AWS guide.
  1. Go to the Configuration page and under Estate, select Monitored servers.
  2. Click Add > Amazon RDS SQL Server. You will be redirected to the Add Amazon RDS SQL Server page:
  3. In the Amazon RDS SQL Server endpoint field, enter the endpoint for the RDS instance provided by AWS, this will end with ".rds.amazonaws.com".
  4. In the username and password fields, enter the credentials for accessing the Amazon RDS SQL Server instance.
  5. You can select a group where the instance will be added, select "Uncategorized" if you don't want to put it in any particular group.
  6. For capturing machine metrics for your Amazon RDS SQL Server instance, you must switch on Enable advanced monitoring and provide AWS credentials.
    1. For information on how to set up advanced monitoring, see our dedicated documentation on Enabling advanced monitoring for RDS instances.




Didn't find what you were looking for?