Benchmark: Database Checks

Thrifty Database Benchmark

Thrifty developers checks old autonomous databases. This benchmark focuses on finding autonomous databases which are older than 90 days.

Variable	Description	Default
autonomous_database_age_max_days	The maximum number of days autonomous databases are allowed to run.	90 days
autonomous_database_age_warning_days	The number of days autonomous databases can be running before sending a warning.	30 days
autonomous_database_avg_cpu_utilization_low	The average CPU utilization required for autonomous databases to be considered infrequently used. This value should be lower than `autonomous_database_avg_cpu_utilization_high`.	20%
autonomous_database_avg_cpu_utilization_high	The average CPU utilization required for autonomous databases to be considered frequently used. This value should be higher than `autonomous_database_avg_cpu_utilization_low`.	35%

Install the mod:

mkdir dashboards
cd dashboards
powerpipe mod init
powerpipe mod install github.com/turbot/steampipe-mod-oci-thrifty

Start the Powerpipe server:

steampipe service start
powerpipe server

Open http://localhost:9033 in your browser and select Database Checks.

Run this benchmark in your terminal:

powerpipe benchmark run oci_thrifty.benchmark.database

powerpipe benchmark run oci_thrifty.benchmark.database --share