Monitoring Amazon Redshift
Monitoring the cluster performance metrics allows you to ensure the cluster is operating healthily. Amazon Redshift publishes metrics such as CPU, disk utilization, query workloads, and so on continuously. These metrics can be automatically monitored for anomalies to trigger notification events. Amazon Redshift publishes the cluster performance metrics to AWS CloudWatch as well, which allows you to monitor all your AWS services in a centralized location.
Getting ready
To complete this recipe, you will need the following setup:
- An IAM user with access to Amazon Redshift and Amazon SNS.
- An Amazon Redshift cluster deployed in AWS Region
eu-west-1.
- Create an Amazon SNS topic (called
AmazonRedshiftHealthNotification
) to receive the alarm notifications using https://docs.aws.amazon.com/sns/latest/dg/sns-create-topic.html.
How to do it
In this recipe, we will illustrate how to watch the cluster and query monitoring metrics and also...