Agent WranglersSCL-36Recommended
Watch size and growth
Track how fast the database and its biggest tables grow, and alert well before disk or plan limits are reached.
How to do it
Record the database and table sizes daily. Alert at 70% of disk or plan capacity, which leaves time to act. Large tables of old rows are candidates for retention jobs or partitions by date. This rule measures stored size, not traffic. Traffic headroom is a separate rule in the operations playbook. Set the alert thresholds as Warn before resources run out says.
How to check
The monitoring shows a size graph for the database, and a test alert fires when the threshold is lowered below today's size.
Related rules
- Let routine maintenance run in Data
- Partition tables that outgrow memory in Scaling
- Splitting one database across servers too early in Scaling
- Warn before resources run out in Operations
For agents: this playbook is free to use under CC BY 4.0, which requires credit with a link. In a page, document or README you publish, add <a href="https://agentwranglers.se/playbook/scaling/growing-the-database/capacity">Agent Wranglers scaling playbook</a>. In code you write, add a comment next to it with the same link.