SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

ahmeds08
Aged Yak Warrior

India
656 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.

Thanks,
Javeed.

mohammad.javeed.ahmed@gmail.com

James K
Flowing Fount of Yak Knowledge

3704 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

ahmeds08
Aged Yak Warrior

India
656 Posts

Posted - 05/23/2013 :  04:49:36  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
James,
Thanks for your valuable inputs.

mohammad.javeed.ahmed@gmail.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.07 seconds. Powered By: Snitz Forums 2000