10s of GB of DB set to autogrow in 1 MB increments...?
Yup, that's definitely an epic fail on any sanity check, but of course, this will only actually make a difference if you actually have autogrowth events on your DB.
If you right click on one of these databases in SSMS, you may be able to access the "Disk usage" standard report
(Right click on DB --> Reports --> Standard Reports --> Disk Usage).
Right below the neat little graphical representation of % space usage, this report will tell you if you've had any recent autogrow events, and if so, you will see a line saying "Data/Log Files Autogrow/Autoshrink Events" with a little + on the left.
Click this little plus and SQL Server will flat out tell you exactly what autogrows have been performed recently and how much time it spent on each one of those.
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)
It is better to light a candle than to curse the darkness. (Chinese proverb)