Microsoft Azure Cosmos DB Monitoring
Microsoft Azure Cosmos DB - An Overview
Azure Cosmos DB is a highly scalable, fully managed NoSQL and relational database known for it's exceptional performance and availability. Applications Manager offers a dedicated Azure Cosmos DB monitoring tool with different capabilities for tracking the key performance metrics of Cosmos DB. Performance, RU Consumption rate etc. are few among the metrics that are monitored.
Creating a new Microsoft Azure Cosmos DB Monitor
To learn how to create a new Microsoft Azure Cosmos DB Monitor, click here.
Monitored Parameters
Navigate to the Category View by clicking the Monitors tab. Hover over 'Child Monitors' under Microsoft Azure in the Cloud Apps table, and then select the Cosmos DB monitor from the displayed tooltip. This action will display the bulk configuration view for Azure Cosmos DB in three tabs:
- Availability tab gives the Availability history for the past 24 hours or 30 days.
- Performance tab gives the Health Status and events for the past 24 hours or 30 days.
- List view enables you to perform bulk admin configurations.
Microsoft Azure monitor provides a brief detail of the Azure Cosmos DB under the given subscription. Following are the list of metrics monitored in Azure Cosmos DB Monitoring in their corresponding tabs:
Overview
| Parameter | Description |
|---|
| SERVICE AVAILABILITY |
| Service Availability | The average percentage of account requests availability between the poll interval (in %). |
| NORMALIZED RU CONSUMPTION |
| Normalized RU Consumption | The maximum RU consumption in percentage per minute between the poll interval (in %). |
| TOTAL REQUEST UNITS |
| Total Request Units | The total number of SQL Request Units consumed between the poll interval. |
| REQUESTS/MIN |
| Request Rate | The total number of requests made per minute between the poll interval (in requests/min). |
| METADATA REQUESTS RATE |
| Metadata Requests Rate | The total number of metadata requests made per minute between the poll interval (in requests/min). |
| SERVER LATENCY |
| Server Latency | The average time taken, for the database to process a request and return the results between the poll interval (in seconds). |
| Server Latency (Gateway) | The average server latency, in Gateway Connection Mode between the poll interval (in seconds). |
| Server Latency (Direct) | The average server latency, in Direct Connection Mode between the poll interval (in seconds). |
| PROVISIONED THROUGHPUT |
| Provisioned Throughput | The maximum amount of throughput that is guaranteed to be available for a container or database between the poll interval. |
| AUTOSCALE MAX THROUGHPUT |
| Autoscale Max Throughput | The maximum amount of throughput that a container or database can automatically scale to between the poll interval. |
| PHYSICAL PARTITION |
| Physical Partition Throughput | The maximum available physical partition throughput between the poll interval. |
| Physical Partition Size | The maximum available physical partition size between the poll interval (in GB). |
| P99 REPLICATION LATENCY |
| P99 Replication Latency | The average percentage of P99 Replication Latency, across source and target regions for geo-enabled account between the poll interval (in seconds). |
Cassandra
Note: Metrics shown in Cassandra tab are supported only for Cassandra type in Azure CosmosDB monitor.
| Parameter | Description |
|---|
| CASSANDRA KEYSPACE |
| Cassandra Keyspace Updated | The total number of times a Cassandra keyspace is updated between the poll interval. |
| Cassandra Keyspace Deleted | The total number of times a Cassandra keyspace is deleted between the poll interval. |
| Cassandra Keyspace Created | The total number of times a Cassandra keyspace is created between the poll interval. |
| Cassandra Keyspace Throughput Updated | The total number of times the throughput of a Cassandra keyspace is updated between the poll interval. |
| CASSANDRA TABLE |
| Cassandra Table Created | The total number of times a Cassandra table is created between the poll interval. |
| Cassandra Table Deleted | The total number of times a Cassandra table is deleted between the poll interval. |
| Cassandra Table Updated | The total number of times a Cassandra table is updated between the poll interval. An update can include changes to the table schema, the number of rows, or the throughput. |
| Cassandra Table Throughput Updated | The total number of times the throughput of a Cassandra table is updated between the poll interval. |
| CASSANDRA CONNECTIONS |
| Cassandra Connection Closures | The total number of Cassandra connections that were closed between the poll interval. |
| CASSANDRA REPLICATION LATENCY (AVG) |
| Cassandra Replication Latency (Avg) | The average replication latency for Cassandra connector between the poll interval (in seconds). |
Gremlin
Note: Metrics shown in Gremlin tab are supported only for Gremlin type in Azure CosmosDB monitor.
| Parameter | Description |
|---|
| GREMLIN GRAPH |
| Gremlin Graph Deleted | The total number of Gremlin graphs deleted between the poll interval. |
| Gremlin Graph Updated | The total number of Gremlin graphs updated between the poll interval. |
| Gremlin Graph Created | The total number of Gremlin graphs created between the poll interval. |
| Gremlin Graph Throughput Updated | The total number of Gremlin graph throughputs updated between the poll interval. |
| GREMLIN DATABASE |
| Gremlin Database Created | The total number of Gremlin databases created between the poll interval. |
| Gremlin Database Deleted | The total number of Gremlin databases deleted between the poll interval. |
| Gremlin Database Updated | The total number of Gremlin databases updated between the poll interval. |
| Gremlin Database Throughput Updated | The total number of Gremlin database throughputs updated between the poll interval. |
| GREMLIN REQUESTS |
| Gremlin Request Charges | The total number of request units consumed for Gremlin requests made between the poll interval. |
| Gremlin Requests Rate | The total number of Gremlin requests made per minute between the poll interval (in requests/min). |
MongoDB
Note: Metrics shown in MongoDB tab are supported only for MongoDB type in Azure CosmosDB monitor.
| Parameter | Description |
|---|
| MONGO DATABASE |
| Mongo Database Updated | The total number of Mongo databases updated between the poll interval. |
| Mongo Database Deleted | The total number of Mongo databases deleted between the poll interval. |
| Mongo Database Throughput Updated | The total number of Mongo database throughputs updated between the poll interval. |
| Mongo Database Created | The total number of Mongo databases created between the poll interval. |
| MONGO COLLECTION |
| Mongo Collection Deleted | The total number of Mongo collections deleted between the poll interval. |
| Mongo Collection Updated | The total number of Mongo collections updated between the poll interval. |
| Mongo Collection Created | The total number of Mongo collections created between the poll interval. |
| Mongo Collection Throughput Updated | The total number of Mongo collection throughputs updated between the poll interval. |
| MONGO REQUESTS |
| Mongo Requests Rate | The total number of Mongo requests made per minute between the poll interval (in requests/min). |
| Mongo Request Charge | The total number of Mongo request units consumed between the poll interval. |
NoSQL
Note: Metrics shown in NoSQL tab are supported only for NoSQL type in Azure CosmosDB monitor.
| Parameter | Description |
|---|
| SQL DATABASE OPERATIONS |
| SQL Database Created | The total number of SQL databases created between the poll interval. |
| SQL Database Throughput Updated | The total number of SQL database throughputs updated between the poll interval. |
| SQL Database Deleted | The total number of SQL databases deleted between the poll interval. |
| SQL Database Updated | The total number of SQL databases updated between the poll interval. |
| SQL CONTAINER DETAILS |
| SQL Container Throughput Updated | The total number of SQL container throughputs updated between the poll interval. |
| SQL Container Created | The total number of SQL containers created between the poll interval. |
| SQL Container Deleted | The total number of SQL containers deleted between the poll interval. |
| SQL Container Updated | The total number of SQL containers updated between the poll interval. |
Dedicated Gateway
| Parameter | Description |
|---|
| DEDICATED GATEWAY CPU USAGE |
| Dedicated Gateway CPU Usage (Avg) | The average CPU usage in percentage across dedicated gateway instances between the poll interval (in %). |
| Dedicated Gateway CPU Usage (Max) | The maximum CPU usage in percentage across dedicated gateway instances between the poll interval (in %). |
| DEDICATED GATEWAY MEMORY USAGE |
| Dedicated Gateway Memory Usage (Avg) | The average memory usage across dedicated gateway instances, which is used for both routing requests and caching data between the poll interval (in GB). |
| DEDICATED GATEWAY REQUESTS |
| Dedicated Gateway Requests Rate | The total number of requests at the dedicated gateway per minute between the poll interval (in requests/min). |
Integrated Cache
| Parameter | Description |
|---|
| INTEGRATED CACHE ITEM HIT RATE |
| Integrated Cache Item Hit Rate | The average number of point reads that used the integrated cache divided by number of point reads routed through the dedicated gateway with eventual consistency between the poll interval (in %). |
| INTEGRATED CACHE QUERY HIT RATE |
| Integrated Cache Query Hit Rate | The average number of queries that used the integrated cache divided by number of queries routed through the dedicated gateway with eventual consistency between the poll interval (in %). |
| INTEGRATED CACHE QUERY EXPIRATION COUNT |
| Integrated Cache Query Expiration Count | The average number of queries evicted from the integrated cache due to TTL expiration between the poll interval. |
| INTEGRATED CACHE ITEM EXPIRATION COUNT |
| Integrated Cache Item Expiration Count | The average number of items evicted from the integrated cache due to TTL expiration between the poll interval. |
| INTEGRATED CACHE EVICTED ENTRIES SIZE |
| Integrated Cache Evicted Entries Size | The average size of the entries evicted from the integrated cache between the poll interval (in GB). |
Table
Note: Metrics shown in Table tab are supported only for Table type in Azure CosmosDB monitor.
| Parameter | Description |
|---|
| TABLE DETAILS |
| AzureTable Table Created | The total number of times a table is created between the poll interval. |
| AzureTable Table Deleted | The total number of times a table is deleted between the poll interval. |
| AzureTable Table Throughput Updated | The total number of times the throughput of a table is updated between the poll interval. |
| AzureTable Table Updated | The total number of times a document in a table is updated between the poll interval. |
Configuration
| Name | Value |
|---|
| Provisioning State | Provisioning state of the resource. |
| SQL Endpoint | The SQL endpoint which the connection belongs to. |
| Document Endpoint | The connection endpoint for the specific region. |
| Cassandra Endpoint | The connection endpoint for the Cassandra type of Cosmos DB. |
| Gremlin Endpoint | The connection endpoint for the Gremlin type of Cosmos DB. |
| MongoDB Endpoint | The connection endpoint for the MongoDB type of Cosmos DB. |
| Table Endpoint | The connection endpoint for the Table type of Cosmos DB. |
| Minimal TLS Version | Minimal Transport Layer Security protocol version of the Cosmos DB. |
| Cosmos Type | Type of Cosmos DB. Possible Values:- Cassandra
- Gremlin
- MongoDB
- No SQL
- Table
|
| Public Network Access | Indicates whether or not public endpoint access is allowed. Possible Values: Enabled/Disabled. |
| Location | Geo location where the resource resides. |
| Created At | Time and date of creation. |
| Resource Group Name | Name of the resource group. |
Note: The Cassandra, Gremlin, MongoDb, and Table Endpoint metrics are supported only in corresponding Cosmos type monitor.
