Benchmark: SQL Checks
Thrifty SQL Benchmark
Thrifty developers keep a careful eye for SQL DB instances with low connections and low CPU utilization. This benchmark focuses on finding SQL DB instances that have low connections and low CPU utilization.
Variables
| Variable | Description | Default |
|---|---|---|
| sql_db_instance_avg_connections | The minimum number of average connections per day required for DB instances to be considered in-use. | 2 connections/day |
| sql_db_instance_avg_cpu_utilization_low | The average CPU utilization required for DB instances to be considered infrequently used. This value should be lower than the value for sql_db_instance_avg_cpu_utilization_high. | 25% |
| sql_db_instance_avg_cpu_utilization_high | The average CPU utilization required for DB instances to be considered frequently used. This value should be higher than the value for sql_db_instance_avg_cpu_utilization_low. | 50% |
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-gcp-thriftyStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select SQL Checks.
Run this benchmark in your terminal:
powerpipe benchmark run gcp_thrifty.benchmark.sqlSnapshot and share results via Turbot Pipes:
powerpipe benchmark run gcp_thrifty.benchmark.sql --shareControls
- SQL DB instances with a low number connections per day should be reviewed
- SQL DB instance having low CPU utilization should be reviewed