AWS Database Blog
Category: Amazon CloudWatch
Deliver Amazon RDS Performance Insights counter metrics to a third-party Application Performance Monitoring service provider using Amazon CloudWatch Metrics Stream
This blog post was last reviewed or updated May, 2023. The updated version shown below is based on working backwards from a customer need to use RDS Performance Insights metrics in their APM tool for database observability. Amazon RDS Performance Insights is a feature that monitors Amazon Relational Database Service (Amazon RDS) database instances so […]
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.
How to use CloudWatch metrics to decide between General Purpose or Provisioned IOPS for your RDS database
July 2023: This post was reviewed for accuracy. In this blog post, I talk about how you can use Amazon CloudWatch metrics to understand when you might benefit from provisioned IOPS, also known as IO1 volumes, for highest performance mission-critical database workloads. I start by setting up a test case that simulates a nonbursting consistent […]
Set alarms on Performance Insights metrics using Amazon CloudWatch
Amazon RDS Performance Insights recently released a feature that sends key performance metrics from Performance Insights to Amazon CloudWatch. Using this feature, you can set alerts on these metrics. When Performance Insights is enabled, it automatically sends the following three metrics to CloudWatch: DBLoad DBLoadCPU DBLoadNonCPU I describe these three metrics following. DBLoad The first […]
Analyzing Amazon Elasticsearch Service Slow Logs Using Amazon CloudWatch Logs Streaming and Kibana
September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. Some of our customers have asked for guidance on analyzing Amazon Elasticsearch Service (Amazon ES) slow logs efficiently. Here is what one of these customers said: “We want to identify, understand, and troubleshoot any slow-running queries in our Amazon Elasticsearch […]