Amazon Redshift: The Definitive Guide

Chapter 10. Monitoring and Administration

You can’t improve what you don’t measure.

Peter Drucker

As a fully managed cloud data warehouse, Amazon Redshift continuously monitors your database and automatically captures and stores data related to the resource utilization and details of workloads you run on your data warehouse. As a user of the data warehouse, you can focus on ingesting and analyzing data and need not continuously monitor or administer. Amazon Redshift makes the operational data available for you to monitor and handle exceptions to ensure optimal performance of the data warehouse.

You can view your Amazon Redshift data warehouse operational metrics on the Amazon Redshift console, use AWS CloudWatch, and directly query Amazon Redshift system tables. In this chapter, we will start with an “Amazon Redshift Monitoring Overview” and dive into various options to monitor Amazon Redshift provisioned cluster and serverless. We’ll start with “Monitoring Using Console”, and discuss “Monitoring and Administering Serverless” and “Monitoring Provisioned Data Warehouse Using Console”. Then we will cover both provisioned cluster and serverless “Monitoring Using Amazon CloudWatch” and “Monitoring Using System Tables and Views”. Today, resilience and high availability have becoming important for data warehouse workloads. We will cover how you can set up “High Availability and Disaster Recovery” along with “Snapshots, Backup, and Restore”. Since the monitoring details are stored ...