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.
View your databases
View all databases in your organization, and select a database to view detailed information about the database.
The Dashboard shows all of your databases within your organization, including databases you created and databases created by other team members. From here, you can select an individual database name to manage and connect those databases.
Selecting a database in DataStax Astra DB provides access to detailed information about the database. You can view the keyspaces, size and location of the database, and the estimate cost per hour.
-
Open a browser, navigate to Astra DB, and log in.
-
Select a database from the Databases option in the left navigation or from Recent Resources on the home page.
-
Click the Overview tab.
You can only view connection details and database management operations for databases that you created.
-
You can see several database details from this tab:
-
Database Name
-
Status
-
Usage for current billing period
-
Read Requests
-
Write Requests
-
Storage Consumed
-
Data Transfer
-
-
Compute Size [Only for Classic tier databases]
-
Replication Factor [Only for Classic tier databases]
-
Current Capacity [Only for Classic tier databases]
-
Regions
-
Provider
-
Area
-
Region
-
Datacenter ID
-
Region Availability
-
-
Keyspaces
-
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.