Monitor your databases

View connection details, performance metrics, and health details for databases in your organization.

The Databases page provides an overview of all databases in your organization, including the databases you created and databases created by other team members. However, only a database creator can make changes to a database and view its connection details, which can be shared manually with other team members.

Select a database to view health metrics and performance information. When selecting a database, you can view health metrics that include information regarding latency and throughput to the database. These metrics provide insights into the performance of the database and how workloads are distributed.

When viewing information about a database on the Health page, select the region from the dropdown available at the right to view the health metrics of the database particular to that region. This is only applicable for multi-region databases.

View health dashboard

  1. Open a browser, navigate to DataStax Astra DB, and log in.

  2. On the Databases page, select the database name to view details for. Details for the database display on the Overview tab.

  3. To view health metrics for the database, select the Health tab.

  4. Select the time period to display in the health metrics for.

View health dashboard in full window

  1. Select Cycle View Mode in the upper right corner. This selection displays the cycle view.

  2. Press Esc.

  3. Select the share icon in the upper left corner.

  4. Copy the URL.

  5. Paste the URL in a new browser tab or window to see the dashboard.

Results

Metrics for the database display in the Grafana dashboard embedded in Astra Portal. To view more granular metrics, hover over a specific time in the graph. Read and write latencies display in nanoseconds.

Request Overview

Request Overview

Requests Combined

Displays request rates (req/s) for different types of requests. The rates are summed over all database coordinators.

Request Errors

Displays the request error rates (req/s) for different types of requests. The rates are summed over all database coordinators.

  • Timeouts indicate that the queries are taking too long to complete.

  • Unavailables indicate that the coordinator did not have enough alive data nodes to work with.

  • Failures can be caused by queries violating certain guardrails or other error conditions. For more, see Astra DB database guardrails and limits.

Average Request Complexity

This panel provides a high-level view of the average complexity of database requests. It measures the ratio of the average request units to the average request rate. A higher complexity score indicates that a request is more resource-intensive and expensive in terms of read/write activity. This metric combines write operations, including regular writes, counter writes, and index writes, to provide a comprehensive view of the write request complexity.

Gaps in the read/write metrics are normal; they indicate periods when no read/write requests are happening.

Writes

Writes

Write Latency

Displays coordinator write request latency quantiles on the left y-axis and the total write request rate (req/s) on the right y-axis.

Write Size Distribution

Displays different write request mutation size quantiles. Large mutations can cause performance problems and might even be rejected.

Reads

Reads

Read Latency

Displays coordinator read request latency quantiles on the left y-axis, and the total read request rate (req/s) on the right y-axis.

Range Latency

Displays coordinator range request latency quantiles on the left y-axis, and the total range request rate (req/s) on the right y-axis.

Stargate

Stargeate

Connected Clients

Displays the number of CQL connections

Lightweight Transactions (LWTs)

health lwt

Compare and Set (CAS) Write Latency

Displays coordinator CAS write request latency quantiles on the left y-axis, and the total CAS write request rate (req/s) on the right y-axis.

CAS Write Contention

Displays coordinator CAS write request contention quantiles on the left y-axis and the number of unfinished commits on the right y-axis.

A high number of contended requests negatively affect request latency and cause timeouts. Reduce the number of concurrent requests to the same partition. Unfinished commits cause increased latency. Reducing contention can help reduce the number of unfinished commits.

CAS Read Latency

Displays coordinator CAS read request latency quantiles on the left y-axis, and the total CAS read request rate (req/s) on the right y-axis.

CAS Read Contention

Displays coordinator CAS read request contention quantiles on the left y-axis, and the number of unfinished commits on the right y-axis.

A high number of contended requests negatively affect request latency and cause timeouts. Reduce the number of concurrent requests to the same partition. Unfinished commits cause increased latency. Reducing contention can help reduce the number of unfinished commits.

Tombstones

Tombstones

Tombstones Scanned / s

Displays the number of tombstones being scanned per keyspace, table, and second. A large number of tombstones can cause increased latency or query failures.

Tombstone Guardrail Warnings / s

Displays the number of queries exceeding the tombstone guardrail warning threshold per keyspace, table, and second. For more, see Astra DB database guardrails and limits.

Tombstone Guardrail Failures / s

Displays the number of queries exceeding the tombstone guardrail failure threshold per keyspace, table, and second. For more, see Astra DB database guardrails and limits.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com