Description

This policy identifies Azure PostgreSQL Servers that are potentially underutilized based on their performance metrics over the past 30 days. Underutilized servers are often provisioned at a higher tier than required, resulting in unnecessary cloud costs. A server is flagged as underutilized if its average CPU and I/O utilization are all below 20% and memory is below 40%.

Rationale

Over-provisioned servers increase expenses without delivering corresponding benefits. By identifying and rightsizing underutilized PostgreSQL servers, organizations can reduce costs and improve overall resource efficiency.

Impact

Carefully review to confirm that the new configuration will accommodate peak demand. Note that resizing a server triggers a brief period of downtime while the change is applied.

Audit

This policy evaluates an Azure Azure PostgreSQL Server based on its 30-day performance metrics.

The Server is marked as INCOMPLIANT if:

• Monitor: CPU Percent, 30-Day < 20%.

  and Monitor: IO Consumption Percent, 30-Day < 20%.

  and Monitor: Memory Percent, 30-Day < 40%.

A Server is marked as INAPPLICABLE if it is not currently Ready.

The Server is marked as UNDETERMINED if the metrics are empty, indicating insufficient data in the CMDB to assess utilization.