AWS Database Blog

Category: HAQM CloudWatch

Build a centralized audit data collection for HAQM RDS for PostgreSQL using HAQM S3 and HAQM Athena

Database audits are one of the important compliance requirements that organizations need to meet. You might be required to capture, store, and retain the audit data for the long term. You also need to meet your organization’s information security regulations and standards. In this post, we show you how to capture and store audit data […]

Receive SNS notifications about HAQM RDS for SQL Server when database state changes to Offline or Online

Monitoring is an important aspect for any relational database management system (RDBMS). A good monitoring setup gives us better visibility and control of our database setups. Many of our customers use HAQM CloudWatch metrics and HAQM Relational Database Service (HAQM RDS) event notifications to monitor different metrics and events. HAQM RDS event subscription offers instance-level […]

How to use CloudWatch Logs Insights on HAQM RDS for Oracle log files for real-time analysis

Most database engines log error messages, warnings, traces, and audit statements. Database observability and monitoring are achieved by tracking this log information and taking proactive and reactive actions, such as allocating space when it is low, or stopping sessions causing exclusive locks or connection storms. In HAQM Relational Database Service (HAQM RDS) for Oracle, alert […]

Monitor HAQM RDS Custom for Oracle with HAQM CloudWatch metrics

HAQM Relational Database Service (HAQM RDS) Custom is a managed database service for legacy, custom, and packaged applications that require access to the underlying Operating System (OS) and database environment. With HAQM RDS Custom for Oracle, you can customize the database server host and OS and apply special patches or change database software settings to […]

Send alerts on custom AWS DMS errors from HAQM CloudWatch Logs

AWS Database Migration Service (AWS DMS) is a widely used AWS service to migrate data into the AWS Cloud from on-premises databases or within AWS databases in the cloud. For smooth migrations using AWS DMS, it’s imperative to monitor the AWS DMS resources and tasks, specifically for errors and warnings. Monitoring AWS DMS task via […]

View HAQM CloudWatch logs for HAQM RDS in Splunk Cloud Platform

You can use Splunk Cloud Platform to monitor your entire infrastructure, including database servers hosted in AWS, on premises, or both. In this post we provide you detailed steps on how Splunk can connect to HAQM CloudWatch Logs using AWS Identity and Access Management (IAM) user credentials and pull database log files for HAQM Relational […]

Create an HAQM CloudWatch dashboard to monitor HAQM RDS for PostgreSQL and HAQM Aurora PostgreSQL

Database performance monitoring is critical for application availability and productivity. A good monitoring practice can ensure a small issue is identified in time before it develops into a big problem and causes service disruption. In the AWS Cloud, you can use analytical and monitoring tools like HAQM RDS Performance Insights and HAQM CloudWatch metrics and […]

Monitor deadlocks in SQL Server on HAQM EC2 and set notifications using HAQM CloudWatch

July 2023: This post was reviewed for accuracy. Many of our customers running SQL Server on HAQM Elastic Compute Cloud (HAQM EC2) instances want to capture specific events (systems and user-defined) for monitoring and troubleshooting issues with SQL Server. SQL Server logs these events in its error logs and agent logs. A deadlock is an […]

Analyze database performance with HAQM CloudWatch metric streams

February 9, 2024: HAQM Kinesis Data Firehose has been renamed to HAQM Data Firehose. Read the AWS What’s New post to learn more. With the announcement of HAQM CloudWatch Metric Streams, you can now stream near-real-time metrics data to a destination such as HAQM Simple Storage Service (HAQM S3). Metric Streams supports two primary use […]

Monitor errors in HAQM Aurora MySQL and HAQM RDS for MySQL using HAQM CloudWatch and send notifications using HAQM SNS

May 2023: This post was reviewed and updated for accuracy. Monitoring databases is essential for any DBA, from dev-test databases to mission-critical databases. You want to capture system and user-defined events for monitoring and troubleshooting problems related to your database instance. MySQL records these events in error logs. In this post, we show you how […]