Azure Cosmos DB for PostgreSQL monitor
Though Azure CosmosDB for PostgreSQL can be an effective tool to build your applications, as a decision maker, it becomes necessary to know if the database is running efficiently. For plenty of reasons, there can be considerable replication lag, which could directly affect your interpretation of reports. Plus, with a service like Azure, it is very easy to run out of memory space. You can control this by utilizing Azure Cosmos DB for PostgreSQL monitor.
Table of contents
Setup and Configuration
- Adding Azure Cosmos DB for PostgreSQL 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.
- Go to Cloud > Azure > Add Azure Monitor. You can also follow these steps to add an Azure monitor.
- During Azure monitor configuration, on the Edit Azure Monitor page, select Cosmos DB for PostgreSQL from the Service/Resource Types drop-down.
- Adding Cosmos DB for PostgreSQL to an existing Azure monitor
If you already have an Azure monitor configured for the tenant, you can add Azure Cosmos DB for PostgreSQL by following the steps below:
- Log in to your Site24x7 account.
- Go to Cloud > Azure, select your Azure monitor, then go to any of the dashboards on the left pane of your Azure monitor.
- Click the hamburger
icon and select Edit, which brings you to the Edit Azure Monitor page. - On the Edit Azure Monitor page, select the corresponding Subscriptions and Resource Groups from the drop-down, select Azure Cosmos DB for PostgreSQL from the Service/Resource Types drop-down, and click Save.
- After successful configuration, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL. Now you can view the discovered Azure Cosmos DB for PostgreSQL.
Polling frequency
Site24x7's Azure Cosmos DB for PostgreSQL service monitor collects metric data every five minutes and displays the minute-by-minute status.
Supported metrics
| Metric name | Description | Statistic | Unit |
|---|---|---|---|
| Available Memory Bytes | The physical memory immediately available for a process or to be allocated for system use in the VM | Average | Bytes |
| Disk Read Bytes | The data read from the disk within the monitoring period | Total | Bytes |
| Disk Read Operations/sec | The average disk read input/output (I/O) operations occurring per second | Average | Count per second |
| Disk Write Bytes | The data written to the disk within the monitoring period | Total | Bytes |
| Disk Write Operations/sec | The average disk write I/O operations occurring per second | Average | Count per second |
| Network In Total | The total incoming traffic received by the VM on all network interfaces | Total | Bytes |
| Network Out Total | The total outgoing traffic sent by the VM through all network interfaces | Total | Bytes |
| Percentage CPU | The used compute units from those totally available in the VM | Average | Percent |
Licensing
Azure Cosmos DB for PostgreSQL monitor consumes one basic monitor.
Threshold configuration
- Global configuration
- In the Site24x7 web client, go to the Admin section on the left navigation pane.
- Select Configuration Profiles from the left pane and select Threshold and Availability (+) from the drop-down.
- Click Add Threshold Profile on the top-right corner of the page.
- In the Monitor Type drop-down select Azure Cosmos DB for PostgreSQL.
- Now you can set the threshold values for all the metrics mentioned above.
- Monitor-level configuration
- In the Site24x7 web client, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
- Select the resource you would like to set a threshold for, then click the hamburger icon.
- Select Edit, which directs you to the Edit Azure Cosmos DB for PostgreSQL page.
- You can set the threshold values for the metrics by selecting Threshold and Availability.
- You can also configure IT Automation at the attribute level.
IT Automation
Site24x7's IT Automation tools help automatically resolve performance degradation issues. The alarm engine continually evaluates system events for which thresholds are set and executes the mapped automation when there is a breach.
How to configure IT Automation for a monitor
Configuration Rules
Configuration Rules can be applied to all monitor types in Site24x7. Rules can be configured and associated with existing monitors. Additionally, when a new monitor is being added, you can run a check, and associate any of the previously created rules that match the monitor configurations.
How to add a Configuration Rule
Summary
The Summary tab will give you the performance data organized by time for the metrics listed above.
- To view the summary, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
- Select a resource and click the Summary tab.
- By doing so, you can view the above metrics.
Configuration Details
The configuration details of an Azure Cosmos DB for PostgreSQL resource are provided under the Configuration Detailstab.
- To get the configuration details, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
- Click a resource and select the Configuration Details tab.
Reports
Gain in-depth data about the various parameters of your monitored resources and highlight your service performance using our insightful reports.
To view reports for Azure Cosmos DB for PostgreSQL:
- Go to the Reports section on the left navigation pane.
- Select Azure Cosmos DB for PostgreSQL from the menu on the left.
- You can find the Availability Summary Report, Performance Report, and Inventory Report for one selected monitor, or you can get the Summary Report, Availability Summary Report, Health Trend Report, and Performance Report for all the Azure Cosmos DB for PostgreSQL.
You can also get reports from the Summary tab of the Azure Cosmos DB for PostgreSQL monitor.
Click the Summary tab of the Azure Cosmos DB for PostgreSQL monitor and get the Availability Summary Report of the monitor by clicking Availability or Downtime. You can also find the Performance Report of the monitor by clicking any chart title.