Benchmark: SQL Checks

Thrifty SQL Benchmark

Thrifty developers checks long running SQL databases should be associated with reserved capacity.

Variable	Description	Default
sql_database_age_max_days	The maximum number of days databases are allowed to run.	90 days
sql_database_age_warning_days	The number of days databases can be running before sending a warning.	30 days

Install the mod:

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

Start the Powerpipe server:

steampipe service start
powerpipe server

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

Run this benchmark in your terminal:

powerpipe benchmark run azure_thrifty.benchmark.sql

powerpipe benchmark run azure_thrifty.benchmark.sql --share