Dashboard: SQL Checks
Thrifty SQL Benchmark
Thrifty developers checks long running SQL databases should be associated with reserved capacity.
Variables
| 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 |
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-azure-thriftyStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select SQL Checks dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe benchmark run azure_thrifty.benchmark.sql --shareBenchmark
This dashboard is automatically generated from the following benchmark:
benchmark.sql