It's Almost Always the Queries, Part V: Disk Has Two Alarms, Not One

TL;DR
Two alarms ride the same dashboard tile: the disk filling up, and the disk slowing down. Both have query-level and schema-level fixes that hold for years. Capacity is partition-and-archive, not DELETE. IOPS is covering indexes and the access patterns that go with them. The cloud’s autoscaling and bur...