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.
View health dashboard
-
In the Astra Portal, go to Databases.
-
Select the database that you want to inspect.
-
To view health metrics for the database, click the Health tab.
-
Select the time period to display in the health metrics for.
|
On the Health page for a multi-region database, you can select a region from the menu to scope the data to a particular region. |
View the health dashboard in a full window
-
Select Cycle View Mode.
-
Press Esc.
-
Select the share icon.
-
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.
-
- 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
- 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)
- 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 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.
