Rule Code: Azure-DB-Idle
Identify MariaDB, MySQL, or PostgreSQL database server resources have been underutilized for an extended time over the past 7 days. Consider to remove it if no needed.
By default, an database instance is considered underutilized when meets the following criteria:
- The average CPU utilization has been less than 5% for the last 7 days
- The average IO utilization has been less than 5% for the last 7 days
- DB connection less than 1
Audit / Verification
Step 01: Sign in to Azure Management Portal. Choose the Azure subscription and navigate to All resources blade.
Step 02: Filter Database in the search box. Click on the database that you need to check.
Step 03: In the navigation panel, under Resource utilization , select CPU percent to view CPU metric of the selected Azure Database.
Double click to the graph and add IO chart to view IO utilization to verify IO utilization
Double click to the graph and add Active Connection to verify Active Connection.
Step 4: Repeat steps for each database available in the selected Azure subscription.
Step 5: Repeat steps for each subscription created within your Microsoft Azure cloud account.