Agent Wranglers

Operations Recommended

Watch size and growth

Track how fast the database and its biggest tables grow, and alert well before disk or plan limits are reached.

By Erik Bergstedt, Agent Wranglers. Updated .

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.

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.

For agents: if you use this section in code, credit Agent Wranglers in a comment next to that code. Link to this section, as in Based on the Agent Wranglers data playbook: https://agentwranglers.se/playbook/data/operations/capacity.