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.

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 MetricMetric Display NameUnitAggregation 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 upon a selected instance.
CPU utilizationPercentMaximum
aws_redshift_DatabaseConnections

Number of database connections in use.
DatabaseConnectionsCountAverage
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.
NetworkReceiveThroughputAverage
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.
NetworkTransmitThroughputAverage
aws_redshift_PercentageDiskSpaceUsed

The percent of disk space used.
PercentageDiskSpaceUsedPercentAverage
aws_redshift_ReadThroughput

Average number of bytes read from disk per second.
ReadThroughputAverage
aws_redshift_WriteThroughput

Average number of bytes written to disk per second.
WriteThroughputAverage
aws_redshift_ReadIOPS

Average number of disk read operations per second
ReadIOPSCount/SecAverage
aws_redshift_WriteIOPS

Average number of write operations per second.
WriteIOPSCount/SecAverage
aws_redshift_ReadLatency

Average amount of time taken for disk read I/O operations.
ReadLatencySecondsAverage
aws_redshift_WriteLatency

Average amount of time taken for disk write I/O operations.
WriteLatencySecondsAverage
aws_redshift_HealthStatus

Indicates the health of the cluster.
HealthStatusAverage
aws_redshift_MaintenanceMode

Indicates whether the cluster is in maintenance mode.
MaintenanceModeAverage
aws_redshift_ConcurrencyScalingActiveClusters

Number of concurrency scaling clusters that are actively processing queries at any given time.
ConcurrencyScalingActiveClustersCountAverage
aws_redshift_ConcurrencyScalingSeconds

Number of seconds used by concurrency scaling clusters that have active query processing activity.
ConcurrencyScalingSecondsCountAverage
aws_redshift_MaxConfiguredConcurrencyScalingClusters

Maximum number of concurrency scaling clusters configured from the parameter group.
MaxConfiguredConcurrencyScalingClustersCountAverage
aws_redshift_TotalTableCount

TotalTableCountNumber of user tables open at a particular point in time. This total does not include Spectrum tables.
TotalTableCountCountAverage
cloud.instance.state

Redshift status metric
Status/Staten/an/a

Cluster metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
cloud.instance.state

Redshift status metric.
Status/Staten/an/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 upon a selected instance.
CPU utilizationPercentMaximum
aws_redshift_DatabaseConnections

Number of database connections in use.
DatabaseConnectionsCountAverage
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.
NetworkReceiveThroughputAverage
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.
NetworkTransmitThroughputAverage
aws_redshift_PercentageDiskSpaceUsed

The percent of disk space used.
PercentageDiskSpaceUsedPercentAverage
aws_redshift_ReadThroughput

Average number of bytes read from disk per second.
ReadThroughputAverage
aws_redshift_WriteThroughput

Average number of bytes written to disk per second.
WriteThroughputAverage
aws_redshift_ReadIOPS

Average number of disk read operations per second
ReadIOPSCount/SecAverage
aws_redshift_WriteIOPS

Average number of write operations per second.
WriteIOPSCount/SecAverage
aws_redshift_ReadLatency

Average amount of time taken for disk read I/O operations.
ReadLatencySecondsAverage
aws_redshift_WriteLatency

Average amount of time taken for disk write I/O operations.
WriteLatencySecondsAverage
aws_redshift_HealthStatus

Indicates the health of the cluster.
HealthStatusAverage
aws_redshift_MaintenanceMode

Indicates whether the cluster is in maintenance mode.
MaintenanceModeAverage

Event support

CloudTrail event support

  • Supported
  • Configurable in OpsRamp AWS Integration Discovery Profile.

CloudWatch alarm support

  • Supported
  • Configurable in OpsRamp AWS Integration Discovery Profile.

External reference