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.

Stargate

Stargeate

Connected Clients: Displays the number of CQL connections

Lightweight Transactions (LWTs)

health lwt

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.

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.