Home Forums SQL Server 7,2000 Administration Database Growth RE: Database Growth
spaghettidba
SSC Guru
Points: 105732
More actions
October 21, 2010 at 9:42 am
#1240413
Don't use percent growth. 10% of 150 GB is 15 GB.
While the database grows by 15 GB, performance degrades awfully.
Use fixed size instead.
I usually set data file growth to 100 Mb and log file growth to 50 Mb.
-- Gianluca Sartori