Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud.
An Amazon Redshift data warehouse is a collection of computing resources called nodes. These nodes are organized into a group called a cluster and each cluster runs an Amazon Redshift engine and includes one or more databases.
Use the AWS public cloud integration to discover and collect metrics against the AWS service.
External reference
Monitoring Amazon Redshift using CloudWatch metrics
Setup
To set up the AWS integration and discover the AWS service, go to AWS Integration Discovery Profile and select Redshift.
Event support
CloudTrail event support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
CloudWatch alarm support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
Supported metrics
Standard metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| aws_redshift_CPUUtilization Percentage of allocated EC2 compute units that are currently in use on the instance. This metric identifies the processing power required to run an application On a selected instance. | CPU utilization | Percent | Average |
| aws_redshift_DatabaseConnections Number of database connections in use. | DatabaseConnections | Count | Sum |
| aws_redshift_NetworkReceiveThroughput Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkReceiveThroughput | Average | |
| aws_redshift_NetworkTransmitThroughput Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkTransmitThroughput | Average | |
| aws_redshift_PercentageDiskSpaceUsed The percent of disk space used. | PercentageDiskSpaceUsed | Percent | Average |
| aws_redshift_ReadThroughput Average number of bytes read from disk per second. | ReadThroughput | Average | |
| aws_redshift_WriteThroughput Average number of bytes written to disk per second. | WriteThroughput | Average | |
| aws_redshift_ReadIOPS Average number of disk read operations per second | ReadIOPS | Count/Sec | Average |
| aws_redshift_WriteIOPS Average number of write operations per second. | WriteIOPS | Count/Sec | Average |
| aws_redshift_ReadLatency Average amount of time taken for disk read I/O operations. | ReadLatency | Seconds | Average |
| aws_redshift_WriteLatency Average amount of time taken for disk write I/O operations. | WriteLatency | Seconds | Average |
| aws_redshift_HealthStatus Indicates the health of the cluster. | HealthStatus | Average | |
| aws_redshift_MaintenanceMode Indicates whether the cluster is in maintenance mode. | MaintenanceMode | Average | |
| aws_redshift_ConcurrencyScalingActiveClusters Number of concurrency scaling clusters that are actively processing queries at any given time. | ConcurrencyScalingActiveClusters | Count | Sum |
| aws_redshift_ConcurrencyScalingSeconds Number of seconds used by concurrency scaling clusters that have active query processing activity. | ConcurrencyScalingSeconds | Count | Sum |
| aws_redshift_MaxConfiguredConcurrencyScalingClusters Maximum number of concurrency scaling clusters configured from the parameter group. | MaxConfiguredConcurrencyScalingClusters | Count | Maximum |
| aws_redshift_TotalTableCount TotalTableCountNumber of user tables open at a point in time. This total does not include Spectrum tables. | TotalTableCount | Count | Sum |
| cloud.instance.state Redshift status metric | Status/State | n/a | n/a |
Cluster metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type |
|---|---|---|---|
| cloud.instance.state Redshift status metric. | Status/State | n/a | n/a |
| aws_redshift_CPUUtilization Percentage of allocated EC2 compute units that are currently in use on the instance. This metric identifies the processing power required to run an application On a selected instance. | CPU utilization | Percent | Maximum |
| aws_redshift_DatabaseConnections Number of database connections in use. | DatabaseConnections | Count | Average |
| aws_redshift_NetworkReceiveThroughput Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkReceiveThroughput | Average | |
| aws_redshift_NetworkTransmitThroughput Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | NetworkTransmitThroughput | Average | |
| aws_redshift_PercentageDiskSpaceUsed The percent of disk space used. | PercentageDiskSpaceUsed | Percent | Average |
| aws_redshift_ReadThroughput Average number of bytes read from disk per second. | ReadThroughput | Average | |
| aws_redshift_WriteThroughput Average number of bytes written to disk per second. | WriteThroughput | Average | |
| aws_redshift_ReadIOPS Average number of disk read operations per second | ReadIOPS | Count/Sec | Average |
| aws_redshift_WriteIOPS Average number of write operations per second. | WriteIOPS | Count/Sec | Average |
| aws_redshift_ReadLatency Average amount of time taken for disk read I/O operations. | ReadLatency | Seconds | Average |
| aws_redshift_WriteLatency Average amount of time taken for disk write I/O operations. | WriteLatency | Seconds | Average |
| aws_redshift_HealthStatus Indicates the health of the cluster. | HealthStatus | Average | |
| aws_redshift_MaintenanceMode Indicates whether the cluster is in maintenance mode. | MaintenanceMode | Average |