In sql server 2005, the autogrowth is enabled by size. Is there any way to check when autogrowth on data and log file happened last?
A:
SSMS, right click your db, go to reports->standard reports->disk usage and look for Autogrow/Autoshrink events .
Hopefully you have the correct trace levels set up, if not you might have some issues finding out history.
Nix
2010-09-20 15:41:34
@Nix: Can you tell me if i change this autogrowth size? does it lock the database and block other transactions? How much time does it take?
Novice
2010-09-20 15:49:19