Rule Code: GCP-SQL-Idle
Identify MariaDB, MySQL, or PostgreSQL database server resources have been idle 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 GCP Management Console. Select the GCP Project that you need to examine. Navigate Database - SQL, select the database that you need to examine
Step 02: Double click to the database instance and view metrics
Step 4: Repeat steps for each database available in the selected GCP project.
Step 5: Repeat steps for each subscription created within your GCP account.