standard
turbot/azure_thrifty

Detect & correct Compute disks with high IOPS

Overview

Compute disk with high IOPS cost money.

This query trigger detects Compute disks with high IOPS and then either sends a notification or attempts to perform a predefined corrective action.

Getting Started

By default, this trigger is disabled, however it can be configured by setting the below variables

  • compute_disks_with_high_iops_trigger_enabled should be set to true as the default is false.
  • compute_disks_with_high_iops_trigger_schedule should be set to your desired running schedule
  • compute_disks_with_high_iops_default_action should be set to your desired action (i.e. "notify" for notifications or "snapshot_and_delete_disk" to snapshot and delete the disk).

Then starting the server:

flowpipe server

or if you've set the variables in a .fpvars file:

flowpipe server --var-file=/path/to/your.fpvars

Query

select
concat(
d.id,
' [',
d.resource_group,
'/',
d.subscription_id,
']'
) as title,
d.id as resource,
d.name as disk_name,
d.resource_group,
d.subscription_id,
d.name || to_char(current_date, 'YYYYMMDD') as snapshot_name,
d.sp_connection_name as conn
from
azure_compute_disk as d
left join azure_subscription as sub on sub.subscription_id = d.subscription_id
where
d.disk_iops_read_write > var.compute_disk_max_iops_threshold;

Schedule

15m

Tags

category = Cost
class = unused
plugin = azure
service = Azure/Compute