
Enhance observability for Amazon RDS Custom for SQL Server by installing Prometheus exporters and AWS Distro for OpenTelemetry to send metrics to Amazon Managed Service for Prometheus and visualize them in Amazon Managed Grafana.


<div><p>This article explains how to monitor Amazon RDS Custom for SQL Server using Amazon Managed Service for Prometheus and Amazon Managed Grafana.</p><ul><li>Install Prometheus exporters (windows_exporter and sql_exporter) on RDS Custom instance</li><li>Configure AWS Distro for OpenTelemetry to scrape and remote write metrics</li><li>Create Amazon Managed Prometheus workspace to store metrics</li><li>Set up Amazon Managed Grafana workspace as visualization layer</li><li>Import pre-built SQL Server dashboard (ID 9336) for monitoring</li><li>Use AWS Secrets Manager to securely store database credentials</li><li>Configure IAM roles with AmazonPrometheusRemoteWriteAccess policy</li></ul><p>This solution enables comprehensive monitoring of RDS Custom SQL Server without managing monitoring infrastructure, using fully managed AWS services.</p></div>


Related articles