April 7, 2008 at 3:26 pm
Created a database and configured the initial datafile with 8 GB space. The current amount of data in this datafile is only 1 GB. I enabled autogrow for this datafile to grow at fixed space of 10 MB. I have a developer that claims that we will experience a performance hit because auto grow in enabled, even though we have initially configured with 8 GB space (giving us 7GB free space). He claims that autogrow will perform space checks for each transaction regardless if there is plenty of free space, thus causing a performance issue. Can someone help me out and explain autogrow and if there are reasons that we should not enable autogrow. Thx
April 7, 2008 at 4:55 pm
I don't think the autogrow setting will affect you until it needs to grow. Most experts do not think you should set it autogrow. You definitely should not have it set to only grow 10MB on an 8GB file. You should have it set to at least 10% so that you do not grow often.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply