Introduction
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 contains one or more databases.
Note
Use the OpsRamp AWS public cloud integration to discover and collect metrics against the AWS service.Setup
To set up the OpsRamp AWS integration and discover the AWS service,
go to AWS Integration Discovery Profile and select Redshift.
Metrics
Standard metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| aws_redshift_CPUUtilization | CPU utilization | Percent | MAX | 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 upon a selected instance. |
| aws_redshift_DatabaseConnections | DatabaseConnections | Count | AVERAGE | Number of database connections in use. |
| aws_redshift_NetworkReceiveThroughput | NetworkReceiveThroughput | AVERAGE | Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_redshift_NetworkTransmitThroughput | NetworkTransmitThroughput | AVERAGE | Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_redshift_PercentageDiskSpaceUsed | PercentageDiskSpaceUsed | Percent | AVERAGE | The percent of disk space used. |
| aws_redshift_ReadThroughput | ReadThroughput | AVERAGE | Average number of bytes read from disk per second. | |
| aws_redshift_WriteThroughput | WriteThroughput | AVERAGE | Average number of bytes written to disk per second. | |
| aws_redshift_ReadIOPS | ReadIOPS | Count/Sec | AVERAGE | Average number of disk read operations per second |
| aws_redshift_WriteIOPS | WriteIOPS | Count/Sec | AVERAGE | Average number of write operations per second. |
| aws_redshift_ReadLatency | ReadLatency | Secs | AVERAGE | Average amount of time taken for disk read I/O operations. |
| aws_redshift_WriteLatency | WriteLatency | Secs | AVERAGE | Average amount of time taken for disk write I/O operations. |
| aws_redshift_HealthStatus | HealthStatus | AVERAGE | Indicates the health of the cluster. | |
| aws_redshift_MaintenanceMode | MaintenanceMode | AVERAGE | Indicates whether the cluster is in maintenance mode. | |
| aws_redshift_ConcurrencyScalingActiveClusters | ConcurrencyScalingActiveClusters | Count | Average | Number of concurrency scaling clusters that are actively processing queries at any given time. |
| aws_redshift_ConcurrencyScalingSeconds | ConcurrencyScalingSeconds | Count | Average | Number of seconds used by concurrency scaling clusters that have active query processing activity. |
| aws_redshift_MaxConfiguredConcurrencyScalingClusters | MaxConfiguredConcurrencyScalingClusters | Count | Average | Maximum number of concurrency scaling clusters configured from the parameter group. |
| aws_redshift_TotalTableCount | TotalTableCount | Count | Average | TotalTableCountNumber of user tables open at a particular point in time. This total does not include Spectrum tables. |
| cloud.instance.state | Status/State | n/a | n/a | Redshift status metric |
Cluster metrics
| OpsRamp Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|
| cloud.instance.state | Status/State | n/a | n/a | Redshift status metric. |
| aws_redshift_CPUUtilization | CPU utilization | Percent | MAX | 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 upon a selected instance. |
| aws_redshift_DatabaseConnections | DatabaseConnections | Count | AVERAGE | Number of database connections in use. |
| aws_redshift_NetworkReceiveThroughput | NetworkReceiveThroughput | AVERAGE | Incoming (receive) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_redshift_NetworkTransmitThroughput | NetworkTransmitThroughput | AVERAGE | Outgoing (transmit) network traffic on the DB instance, including both customer database traffic and Amazon RDS traffic used for monitoring and replication. | |
| aws_redshift_PercentageDiskSpaceUsed | PercentageDiskSpaceUsed | Percent | AVERAGE | The percent of disk space used. |
| aws_redshift_ReadThroughput | ReadThroughput | AVERAGE | Average number of bytes read from disk per second. | |
| aws_redshift_WriteThroughput | WriteThroughput | AVERAGE | Average number of bytes written to disk per second. | |
| aws_redshift_ReadIOPS | ReadIOPS | Count/Sec | AVERAGE | Average number of disk read operations per second |
| aws_redshift_WriteIOPS | WriteIOPS | Count/Sec | AVERAGE | Average number of write operations per second. |
| aws_redshift_ReadLatency | ReadLatency | Secs | AVERAGE | Average amount of time taken for disk read I/O operations. |
| aws_redshift_WriteLatency | WriteLatency | Secs | AVERAGE | Average amount of time taken for disk write I/O operations. |
| aws_redshift_HealthStatus | HealthStatus | AVERAGE | Indicates the health of the cluster. | |
| aws_redshift_MaintenanceMode | MaintenanceMode | AVERAGE | Indicates whether the cluster is in maintenance mode. |
Event support
CloudTrail event support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
CloudWatch alarm support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.