PDF
Download PDF
Download page Amazon Redshift.
Amazon Redshift
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and cost-effective to efficiently analyze all your data using your existing business intelligence tools.
Cisco Cloud Observability supports monitoring the following Amazon Redshift entities:
- Node: A computing resource. Amazon Redshift offers different node types to accommodate your workloads.
- Cluster: A group of nodes. Each cluster runs an Amazon Redshift engine and contains one or more databases.
You must configure cloud connections to monitor this entity. See Set up Cisco AppDynamics Cloud Collectors to Monitor AWS.
Cisco Cloud Observability displays AWS entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.
This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.
Detail View
To display the detail view for Amazon Redshift:
- Navigate to the Observe page.
- Under Data Streams & Workflows, click AWS Redshift Clusters.
The list view now displays. - From the list, click an instance Name to display the detail view.
The detail view displays the metrics, key performance indicators, and properties (attributes) related to the instance you selected.
- Navigate to the Observe page.
- Under Data Streams & Workflows, click AWS Redshift Clusters.
- From the left-side Relationships panel, click AWS Redshift Nodes.
The list view now displays. - From the list, click an instance Name to display the detail view.
The detail view displays the metrics, key performance indicators, and properties (attributes) related to the instance you selected.
Metrics and Key Performance Indicators
Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Amazon Redshift. See Monitoring Amazon Redshift using CloudWatch metrics.
| Display Name | Source Metric | Description |
|---|---|---|
| CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. For clusters, this metric represents an aggregation of all nodes (leader and compute) CPU utilization values. |
| Commit Queue Length (Count) | CommitQueueLength | The number of transactions waiting to commit at a given point in time. |
| Concurrency Scaling Active Clusters (Count) | ConcurrencyScalingActiveClusters | The number of concurrency scaling clusters that are actively processing queries at any given time. |
| Concurrency Scaling Seconds | ConcurrencyScalingSeconds | The number of seconds used by concurrency scaling clusters that have active query processing activity. |
| Max Configured Concurrency Scaling Clusters (Count) | MaxConfiguredConcurrencyScalingClusters | Maximum number of concurrency scaling clusters configured from the parameter group. |
| Database Connections (Count) | DatabaseConnections | The number of database connections to a cluster. |
| Health Status (0/1) | HealthStatus | Indicates the health of the cluster. Every minute the cluster connects to its database and performs a simple query. If it is able to perform this operation successfully, the cluster is considered healthy. Otherwise, the cluster is unhealthy. An unhealthy status can occur when the cluster database is under extremely heavy load or if there is a configuration problem with a database on the cluster. |
| Network Throughput (By/s) | NetworkReceiveThroughput | The rate at which the node or cluster receives data. |
NetworkTransmitThroughput | The rate at which the node or cluster writes data. | |
| Percentage Disk Space Used | PercentageDiskSpaceUsed | The percent of disk space used. |
| Queries Completed Per Second | QueriesCompletedPerSecond | The average number of queries completed per second. Reported in 5-minute intervals. This metric isn't supported on single-node clusters. |
| Query Duration (us) Queue Depth | QueryDuration | The average amount of time to complete a query. Reported in 5-minute intervals. This metric isn't supported on single-node clusters. |
| Num Exceeded Schema Quotas Queue Depth (Count) | NumExceededSchemaQuotas | The number of schemas with exceeded quotas. |
| Redshift Managed Storage Total Capacity (MBy) | RedshiftManagedStorageTotalCapacity | Total managed storage capacity. |
| Total Table Count | TotalTableCount | The number of user tables open at a particular point in time. This total doesn't include Amazon Redshift Spectrum tables. |
| Latency (s) | ReadLatency | The average amount of time taken for disk read I/O operations. |
WriteLatency | The average amount of time taken for disk write I/O operations. | |
| Throughput (By) | ReadThroughput | The average number of bytes read from disk per second. |
WriteThroughput | The average number of bytes written to disk per second. | |
| IOPs (Count/s) | ReadIOPS | The average number of disk read operations per second. |
WriteIOPS | The average number of write operations per second. |
| Display Name | Source Metric | Description |
|---|---|---|
| CPU Utilization (%) | CPUUtilization | The percentage of CPU utilization. |
| Network Throughput (By/s) | NetworkReceiveThroughput | The rate at which the node or cluster receives data. |
NetworkTransmitThroughput | The rate at which the node or cluster writes data. | |
| Percentage Disk Space Used | PercentageDiskSpaceUsed | The percent of disk space used. |
| Queries Completed Per Second | QueriesCompletedPerSecond | The average number of queries completed per second. Reported in 5-minute intervals. This metric isn't supported on single-node clusters. |
| Query Duration (us) Queue Depth | QueryDuration | The average amount of time to complete a query. Reported in 5-minute intervals. This metric isn't supported on single-node clusters. |
| Latency (s) | ReadLatency | The average amount of time taken for disk read I/O operations. |
WriteLatency | The average amount of time taken for disk write I/O operations. | |
| Throughput (By) | ReadThroughput | The average number of bytes read from disk per second. |
WriteThroughput | The average number of bytes written to disk per second. | |
| IOPs (Count/s) | ReadIOPS | The average number of disk read operations per second. |
WriteIOPS | The average number of write operations per second. |
Properties (Attributes)
Cisco Cloud Observability displays the following properties for Amazon Redshift.
| Display Name | Property Name | Description |
|---|---|---|
| ARN | aws.redshift_cluster.id | The unique identifier of the Redshift cluster. |
Node Type | aws.redshift_cluster.node_type | The node type for the nodes in the cluster. |
| Cluster Status | aws.redshift_cluster.status | The current state of the cluster. |
| Availability Status | aws.redshift_cluster.availability_status | The availability status of the cluster for queries. |
| DB Name | aws.redshift_cluster.db_name | The name of the initial database that was created when the cluster was created. If an initial database was not specified, a database named dev dev was created by default. |
| DNS Address | aws.redshift_cluster.address | The DNS address of a cluster. |
| Port | aws.redshift_cluster.port | The port the DB engine is listening to. |
| Public Access | aws.redshift_cluster.publicly_accessible | A boolean value that, if true, indicates that the cluster can be accessed from a public network. |
| Version | aws.redshift_cluster.version | The version ID of the Amazon Redshift engine that is running on the cluster. |
| Created At | aws.redshift_cluster.creation_time | The time at which the cluster was created. |
Nodes | aws.redshift_cluster.node_count | The number of nodes present in a cluster. |
| Node IDs | aws.redshift_cluster.node_ids | The identifiers (roles) of the nodes in a cluster. |
| Encrypted | aws.redshift_cluster.is_encrypted | A boolean value that, if true, indicates that data in the cluster is encrypted at rest. |
VPC ID | aws.redshift_cluster.vpc_id | The ID of an associated VPC. |
| Display Name | Property Name | Description |
|---|---|---|
| Name | aws.redshift_node.id | The ID of a node. |
| Cluster Identifier | aws.redshift_node.cluster_id | The ID of cluster a node belongs to. |
| Private Address | aws.redshift_node.private_ip | The private IP address of a node within a cluster. |
| Public Address | aws.redshift_node.public_ip | The public IP address of a node within a cluster. |
Retention and Purge Time-To-Live (TTL)
For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).
Amazon Web Services, the AWS logo, AWS, and any other AWS Marks used in these materials are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.