November 11, 2009 at 11:42 am
Hi,
We have MOSS 2007 with SP1 (Share point) databases on SQL Server 2005 EE x64 with SP3. We DO NOT have an estimate of database growth and I need to depend on Autogrowth settings for databae growth.
Currently, all the database's auto growth is set to default i.e 10% autogowth for both data file & log file.
I'm thinking to change these default Autogrowth settings to 50 MB for both data file & log file.Because couple of content database's size is 25 GB and if those database needs to grow, it will try to increase by 10% i.e 2.5 GB in singlle attempt & which will cause contension right? So changing the Autogrow settings to 50 MB makes sense?
thanks for your inputs
November 11, 2009 at 11:54 am
Change the Autogrowth setting from % to MB value makes sense, but I am worried with the 50 MB value, it is too low for Large Databases.
It would be ok for a small Databases, I generally prefer to do that by monitoring how much of the Log File is being utilized.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 11, 2009 at 11:56 am
50 MB may be a little small. I usually use at least 100 MB, but for a database that I expect to grow fairly often, 500 MB or more might be good.
If you are running Windows Server 2003 or later, and the service account is an admin on the server, then allocation of new space is fairly fast.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply