Tuesday, January 8, 2013

Monitoring SQL Server Auto-Growths

On a periodic basis I'll do some analysis of data and transaction log file growths to see if my auto-growth increments should be adjusted.  I realize some prefer to not enable auto-growth, but I'm fine allowing my data files to grow automatically - I just make sure I monitor and adjust accordingly.

This is the script I run periodically to get a high-level summary of auto-growths in my current default trace file - if you use a Central Management Server, you could run this against all your instances at once.

The results will look something like this - I have removed my database names: