Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Database Autogrowth Setting
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Aged Yak Warrior

737 Posts

Posted - 05/22/2013 :  03:38:12  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Dear Experts,
I have been monitoring my database growth for the last two weeks.
And found that the database has grown by 3 GB in the last two weeks.
Current auto growth setting of the data file is auto grow by 1 MB.
So, can I change the auto growth setting to auto grow by 3 GB so that I can avoid frequent auto growth events on the database.


James K
Flowing Fount of Yak Knowledge

3873 Posts

Posted - 05/22/2013 :  08:18:46  Show Profile  Reply with Quote
You can set the autogrowth to 3GB, or something else. But ideally what you should do is monitor the growth, and increase the size yourself manually before it needs to autogrow, so it won't have to autogrow. Autogrowth can happen any time, and if it is during the busiest time of the day, that can adversely impact the performance. When you manually increase the size, you have control over when you do it. Leave the allow-autogrowth enabled though, in case there is a spurt of activity and it needs to autogrow.

This goes for both the data files and log files.
Go to Top of Page

Aged Yak Warrior

737 Posts

Posted - 05/23/2013 :  04:49:36  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
Thanks for your valuable inputs.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000