AWS Database Blog
Author: Nithin Reddy Cheruku
Nithin Reddy Cheruku is a Cloud Architect with AWS Professional Services with a focus on DevOps and AI/ML. In his spare time, he enjoys watching movies, playing cricket and tinkering with technology.
Monitor your Microsoft SQL Server using custom metrics with Amazon CloudWatch and AWS Systems Manager
In this blog post, we show you how to configure the CloudWatch agent on Amazon EC2 Windows instances to capture custom metrics for SQL Server from Windows performance monitor. We also show you how to publish those custom metrics and monitor them on Amazon CloudWatch console. We also walk you through on how to store custom configuration in AWS Systems Manager Parameter Store used by CloudWatch agent to capture those metrics and reuse the same configuration across multiple fleets of SQL Server instances where similar kind of metrics are needed.