Alerting on Autogrowth Events
Alerting on Autogrowth Events, some environments set the file size of their databases and would like to be alerted if autogrowth occurs since that indicates abnormal behavior
Hugo Kornelis commented
I have created a custom metric that simply returns the total size of all database files and alerts on a change in the returned value. I'll see if I can submit it to the custom metric collection. (But it's very easy to build yourself)
Ally Parker @ Redgate commented
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