Help Cosmos DB for PostgreSQL

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:

    1. Log in to your Site24x7 account.
    2. Go to Cloud > Azure > Add Azure Monitor. You can also follow these steps to add an Azure monitor.
    3. 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:

    1. Log in to your Site24x7 account.
    2. Go to Cloud > Azure, select your Azure monitor, then go to any of the dashboards on the left pane of your Azure monitor.
    3. Click the hamburger hamburger icon icon and select Edit, which brings you to the Edit Azure Monitor page.
    4. 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.
    5. 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.
It will take 15-30 minutes to discover new Azure resources. For immediate discovery of the selected configuration, go to the Infrastructure Dashboard of the Azure monitor, hover over the hamburger icon, and select Discover Now.

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 nameDescriptionStatisticUnit
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
    1. In the Site24x7 web client, go to the Admin section on the left navigation pane.
    2. Select Configuration Profiles from the left pane and select Threshold and Availability (+) from the drop-down.
    3. Click Add Threshold Profile on the top-right corner of the page.
    4. In the Monitor Type drop-down select Azure Cosmos DB for PostgreSQL.
    5. Now you can set the threshold values for all the metrics mentioned above.
  • Monitor-level configuration
    1. In the Site24x7 web client, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
    2. Select the resource you would like to set a threshold for, then click the hamburger hamburger icon icon.
    3. Select Edit, which directs you to the Edit Azure Cosmos DB for PostgreSQL page.
    4. You can set the threshold values for the metrics by selecting Threshold and Availability.
    5. 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.

  1. To view the summary, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
  2. Select a resource and click the Summary tab.
  3. 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.

  1. To get the configuration details, go to Cloud > Azure > Azure Monitor > Azure Cosmos DB for PostgreSQL.
  2. 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:

  1. Go to the Reports section on the left navigation pane.
  2. Select Azure Cosmos DB for PostgreSQL from the menu on the left.
  3. 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.

Related links

Was this document helpful?
Thanks for taking the time to share your feedback. We’ll use your feedback to improve our online help resources.

Help Cosmos DB for PostgreSQL