Check Details

• Resource: Azure Cosmos DB for PostgreSQL
• Check: Ensure CPU utilization Is Monitored
• Risk: Without proper CPU monitoring, performance degradation, unexpected workload spikes, or resource exhaustion may go unnoticed, potentially leading to service disruption and reduced application availability.

Remediation via Azure Portal

1. Log in to the Azure Portal.
2. Navigate to Azure Cosmos DB for PostgreSQL and select the relevant server group.
3. Under Monitoring, select Metrics.
4. From the metric drop-down menu, select CPU percent.
5. Configure an Alert rule based on CPU utilization:
   • Click New alert rule.
   • Define an appropriate threshold (for example, greater than 80%).
   • Select an action group for notifications.
   
6. Review and create the alert rule to enable proactive monitoring.

Remediation via Azure CLI

1. Open Azure Cloud Shell or a local terminal with Azure CLI installed.
2. Retrieve available CPU metrics for the server group:
   

   az monitor metrics list-definitions \
    --resource <resource-id> \
    --query "[?contains(name.value, 'cpu')]"
   

3. Create a CPU utilization alert rule:
   

   az monitor metrics alert create \
    --name "HighCPUAlert" \
    --resource-group <resource-group> \
    --scopes <resource-id> \
    --condition "avg cpu_percent > 80" \
    --description "Alert when CPU utilization exceeds 80 percent" \
    --evaluation-frequency 5m \
    --window-size 5m
   

4. Verify that the alert rule has been created:
   

   az monitor metrics alert list \
    --resource-group <resource-group> \
    --output table
   

Replace <resource-group> and <resource-id> with your actual values. The alert rule ensures CPU utilization is continuously monitored and appropriate action can be taken when thresholds are exceeded.