turbot/azure_thrifty
Loading controls...

Control: Disks with high IOPS should be resized if too large

Description

High IOPS disks are costly and usage should be reviewed.

Usage

Run the control in your terminal:

powerpipe control run azure_thrifty.control.compute_disk_high_iops

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run azure_thrifty.control.compute_disk_high_iops --share

Steampipe Tables

Params

ArgsNameDefaultDescriptionVariable
$1compute_disk_max_iops
2000
The maximum IOPS allowed for disks.

SQL

select
disk.id as resource,
case
when disk_iops_read_write > $1 then 'alarm'
else 'ok'
end as status,
disk.title || ' has ' || disk_iops_read_write || ' IOPS.' as reason,
disk.resource_group,
display_name as subscription
from
azure_compute_disk as disk,
azure_subscription as sub
where
sub.subscription_id = disk.subscription_id;

Tags