Azure Cosmos DB for Apache Cassandra monitoring integration

Azure Cosmos DB for Apache Cassandra is suitable for storing data for applications designed for Apache Cassandra.

With Site24x7's integration, you can monitor your database with accurate metrics, configure thresholds, and get instant alerts if there is a breach.

Setup and configuration

Adding an Azure Cosmos DB for Apache Cassandra while configuring a new Azure monitor

If you haven't configured an Azure Monitor yet, add one by following the steps below:

Log in to your Site24x7 account.
Choose Cloud from the left navigation pane, and select Azure > Add Azure Monitor. You can also follow these steps to add an Azure Monitor.
During Azure monitor configuration, in the Add Azure Monitor page, select Azure Cosmos DB for Apache Cassandra along with other required resource types from the Service/Resource Types drop-down. Check if you have configured the corresponding Resource groups and Tag filters in the Edit page.

Adding an Azure Cosmos DB for Apache Cassandra to an existing Azure monitor

If you already have an Azure monitor configured for the tenant, you can add the Azure Cosmos DB for Apache Cassandra using the following steps:

Log in to your Site24x7 account.
Navigate to Cloud > Azure > select the Azure monitor from the left pane for which you wish to add an Azure Cosmos DB for Apache Cassandra.
In the Service View page, click the Enable Monitoring button in the Azure Cosmos DB for Apache Cassandra Service type. Check if you have configured the corresponding Resource groups and tag filters in the Edit page.

Note

It will take 15-30 minutes to discover new Azure resources. To immediately discover the selected configuration, click Discover Now in the top-right corner, by doing which all the resources that match the filters configured in Azure Edit page will be discovered even if the Auto-Discover New Resources option is disabled.

Now, you can view the discovered databases from the Service View dashboard itself.

Polling frequency

Site24x7's Azure Cosmos DB for Apache Cassandra monitor collects metric data every minute and the statuses from your applications every five minutes.

Supported metrics

Usage

Metric	Description	Statistic	Unit
Service Availability	The percentage of availability requests made by the account at one hour, day, or month granularity	Average	Percent
Metadata Requests	The number of metadata requests. Cosmos DB maintains a system metadata collection for each account, which allows users to enumerate collections, databases, etc., and their configurations free of charge	Count	Count
Data Usage	The total data usage reported at five minutes granularity	Average	Bytes
Index Usage	The total index usage reported at five minutes granularity	Average	Bytes
Document Count	The total document count reported at five minutes, one hour, and one day granularity	Average	Count
Document Quota	The total storage quota reported at five minutes granularity	Average	Bytes
Account Created	The number of accounts created	Count	Count
Account Deleted	The number of accounts deleted	Count	Count
Total Requests	The total number of requests made	Count	Count
Total Request Units	The number of SQL request units consumed	Average	Count
Normalized RU Consumption	The percentage of maximum RU consumed per minute	Average	Percent
Autoscaled RU	The number of autoscaled RU consumed per region and per partition autoscale	Maximum	Count
Account Keys Updated	The number of updated account keys	Count	Count
Account Network Settings Updated	The number of updated account network settings	Count	Count
Autoscale Max Throughput	The number of throughputs that autoscale in the particular database	Maximum	Count
Provisioned Throughput	The number of provisioned throughputs	Maximum	Count
Account Replication Settings Updated	The number of updated account replication settings	Count	Count
Account Diagnostic Settings Updated	The number of updated account diagnostic settings	Count	Count
Materialized View Catchup Gap In Minutes	The maximum time difference between data in source container and data propagated to materialized view	Maximum	Count
Materialized Views Builder Average CPU Usage	Average CPU usage across materialized view builder instances, which are used for populating data in materialized views	Average	Percent
Materialized Views Builder Average Memory Usage	Average memory usage across materialized view builder instances, which are used for populating data in materialized views	Average	Bytes
Materialized Views Builder Maximum CPU Usage	Average Maximum CPU usage across materialized view builder instances, which are used for populating data in materialized views	Average	Percent

Resilience

Metric	Description	Statistic	Unit
Server Side Latency	The amount of latency recorded on the server side	Average	Milliseconds
Server Side Latency Direct	The amount of latency recorded in the server side on direct connection mode	Average	Milliseconds
Server Side Latency Gateway	The amount of latency recorded on the server side in gateway connection mode	Average	Milliseconds
Physical Partition Count	The number of physical partitions	Maximum	Count
Physical Partition Size	The size of physical partition	Average	Bytes
Physical Partition Throughput	The number of physical partition throughputs	Maximum	Count
Region Added	The number of regions added	Count	Count
Region Removed	The number of regions removed	Count	Count
Region Offlined	The number of regions made offline	Count	Count
Region Onlined	The number of regions made online	Count	Count
Region Failed Over	The number of regions that failed over	Count	Count
P99 Replication Latency	The amount of P99 replication latency across source and target regions for geo-enabled account	Average	Milliseconds

Cassandra

Metric name	Description	Statistic	Unit
Cassandra Connection Closures	The number of Cassandra connections that were closed, reported at a one minute granularity	Average	Count
Cassandra Connector Average Replication Latency	The amount of latency occured during the Cassandra connector replication	Average	Milliseconds
Cassandra Connector Replication Health Status	The health status count of the Cassandra connector replication	Count	Count
Cassandra Keyspace Created	The total number of Cassandra keyspaces created	Count	Count
Cassandra Keyspace Deleted	The total number of Cassandra keyspaces deleted	Count	Count
Cassandra Keyspace Throughput Updated	The total number of Cassandra keyspace throughputs updated	Count	Count
Cassandra Keyspace Updated	The total number of Cassandra keyspaces updated	Count	Count
Cassandra Request Charges	The average amount of RUs (request units) consumed for the Cassandra requests made	Average	Count
Cassandra Requests	The number of Cassandra requests made	Count	Count
Cassandra Table Created	The number of Cassandra tables created	Count	Count
Cassandra Table Deleted	The number of Cassandra tables deleted	Count	Count
Cassandra Table Throughput Updated	The number of Cassandra table throughputs updated	Count	Count
Cassandra Table Updated	The number of Cassandra tables updated	Count	Count

Threshold configuration

Associating a threshold profile can be done from the monitor Edit page:

Under Configuration Profiles > Threshold and Availability > select the corresponding threshold profile from the drop-down.

Note

The changes done for this threshold profile will be applied to all the associated monitors. You can either add or edit the threshold profile by clicking the + or

pencil icon respectively.

Bulk Action:

Bulk association of threshold profiles can be done from Admin page (Admin > Inventory > Bulk Action > Under Monitor Configuration, go to Modify Threshold Profile).

You can set the threshold values for the metrics by selecting the Threshold and Availability option. You can also configure IT automation at the attribute level.

Default thresholds

Site24x7 alerts you based on a set of default thresholds. These default thresholds ensure that your database capacity is not overutilized, thus maintaining optimal storage and performance. This also helps in reducing costs. The default thresholds are provided for the below metrics:

Public Network Access Changed
Default Consistency Policy Changed
Service Availability
Normalized RU Consumption
Account Keys Updated
Region Removed
Cassandra Table Updated
Cassandra Table Deleted
Cassandra Keyspace Updated
Cassandra Keyspace Deleted

IT automation

Site24x7 offers a set of exclusive IT automation tools to auto-resolve performance degradation issues. These tools react to events proactively rather than waiting for manual intervention.

How to configure IT Automation for a monitor.

Configuration Rules

With Site24x7's Configuration Rules, you can set parameters like Threshold Profile, Notification Profile, Tags, and Monitor Group for multiple monitors. These rules can be configured and run for the existing or new monitors (during addition) matching the given criteria.

How to add a configuration rule.

Reports

Gain in-depth data about the various parameters of your monitored resources and accentuate your service performance using our insightful reports.

To view reports for an Azure Cosmos DB for Apache Cassandra:

Navigate to the Reports section on the left navigation pane.
Select Azure Cosmos DB for Apache Cassandra from the menu on the left.

You can find the Availability Summary Report, and Performance Report for one selected monitor, or you can get the Inventory Report, Summary Report, Availability Summary Report, Health Trend Report, and Performance Report for all the monitors.

Schedule reports

You can also schedule the Inventory Report by navigating to Reports > Azure Cosmos DB for Apache Cassandra > Inventory Report and clicking the Share This button at the top-right corner. In the Schedule Report pop-up, choose the monitor, assign the desired frequency—daily, weekly, monthly, or quarterly—and receive the regular reports of your inventory details to the groups that you desire.

Site24x7 Azure Cosmos DB for Apache Cassandra monitoring also provides CosmosDB for Apache Cassandra by Default Consistency Level reports that will enable you to gain deeper insight into your resources.

Top N and Bottom N reports

Service Availability
Normalized RU Consumption
Data Usage
Index Usage
Document Count
Total Requests
Provisioned Throughput

You can also view the reports from the Usage tab of the Azure Cosmos DB for Apache Cassandra Monitor.

Go to the Usage tab of the Azure Cosmos DB for Apache Cassandra Monitor, and get the Availability Summary Report of the monitor by clicking on Availability.
You can also find the Performance Report of the monitor by clicking on any chart title.

Site24x7's Cosmos DB for Apache Cassandra monitoring interface

Get an overview of the availability and usage status of your Cosmos DB for Apache Cassandra.

Usage:

The Usage tab will help you view the data and index usage of your resource as well as the availability status of your service and database. You can view metrics like Metadata Requests, Normalized RU Consumption, Provisioned Throughput, and many more.

Resilience:

With the Resilience tab, you can view the latency details, partition information, and the status of the regions.

Cassandra:

The Cassandra tab will provide the details of your Apache Cassandra table and keyspace, the requests received and charged along with the throughput information.

Configuration Details:

This tab provides the configuration details of your Cosmos DB for Apache Cassandra. Details on the Cassandra EndPoint, Public Network Access, Default Consistency Level, Backup Policy Type, Backup Retention Interval, and many more are included in this section.

Zia Forecast:

By leveraging the AI-driven Zia framework, you can examine resource consumption measurements through the forecast chart located in the Zia Forecast tab. This chart predicts upcoming performance metrics based on a 7-day historical data analysis, providing insights into the expected metric usage for the next seven days.

Outages:

This tab provides the history of the Cosmos DB for Apache Cassandra statuses, including Down, Trouble, and Critical.

Inventory:

This provides the licensing details, the Threshold and Availability Profiles, the Notification Profiles set, the set User Alert Group, and the monitor created time and modified time.

Log Report:

The Log Report tab lists all the logs collected during every data collection, along with their statuses.