View health and metrics
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
-
Open a browser, navigate to DataStax Astra DB, and log in.
-
On the Databases page, select the database name to view details for. Details for the database display on the Overview tab.
-
To view health metrics for the database, select the Health tab.
-
Select the time period to display in the health metrics for.
View health dashboard in full window
-
Select Cycle View Mode in the upper right corner. This selection displays the cycle view.
-
Press Esc.
-
Select the share icon in the upper left corner.
-
Copy the URL.
-
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
- 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.
-
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
- 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.
Lightweight Transactions (LWTs)
- Column Access Strobe (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 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.