Alert When Data Files Have Less Potential Growth than Autogrowth

• Greg Roberts-134214

  SSCommitted

  Points: 1686

  More actions

  July 12, 2013 at 3:04 pm

  #395137

  I have a production database that grows at a rate of approximately 5 GB per week and is 1.2 TB in total size currently. We have a weekly task to grow the files at a rate equal to our expected growth, thus avoiding autogrowth events. But occasionally there is unusual growth and an autogrowth event does occur. We also have the data files configured with maximum size limits to avoid filling storage devices and also the performance impact of jumbo files. Our current max is 250GB / file. I know that's too big but it's better than no limit. 😀

  Our production DBAs routinely monitor the database to make sure the file has not hit that bad place of Potential Growth = 0 MB. This condition was discovered today.

  My question is, how can I automatically monitor and alert for the condition Potential Growth <= 2 * Autogrowth?

  I am using Idera SQL Diagnostic Manager, which provides reasonable monitoring, but i have not been able to find a way to alert on this condition in the tool.

  Thanks in advance,

  Greg

  ---

  Greg Roberts