Hi,

Thanks for your suggestion. There’s an alert type called Database File Usage that might solve this for you – this alert will trigger when you are within a certain amount of time of an autogrowth event (eg DB file 1 will grow in 7 days).

By default it’s switched off for databases that have autogrowth enabled so you’ll need to uncheck that option first.

There’s some details on this alert here: http://documentation.red-gate.com/display/SM8/List+of+alerts#Listofalerts-DatabaseFileUsage

It is also possible to add custom metrics to monitor autogrowth, for example:
- be alerted when the number of autogrowth events that occur on the data file or log file of a database goes above defined thresholds: http://sqlmonitormetrics.red-gate.com/database-autogrowth/
- be notified when the number of available steps gets too low: http://sqlmonitormetrics.red-gate.com/database-growth-steps-available/

We’d be grateful if you could confirm if the Database File Usage alert or custom alerts meet your requirements, or if you feel there are further improvements we could make. This will allow us to consider your suggestion in more detail or close it and return your votes.

Thanks for your support,
SQL Monitor Development Team