July 8, 2015 at 9:47 pm
pls give me the best autogrowth & initial size setting for database
July 8, 2015 at 9:54 pm
giri10488 (7/8/2015)
pls give me the best autogrowth & initial size setting for database
It depends. One thing, don't use a percentage.
It depends on the expected size of the database plus growth over 3 to 6 months. You also want it large enough that IF an autogrowth event occurs it is enough to handle continued growth for a period of time, like a month or so.
You should be monitoring available space and grow it manually every 3 to 6 months depending on activity on the database.
July 8, 2015 at 10:08 pm
hi lynn
i am creating database so suggest me what will be the best autogrowth setting as i dont know how it will grow.
July 8, 2015 at 10:22 pm
giri10488 (7/8/2015)
hi lynni am creating database so suggest me what will be the best autogrowth setting as i dont know how it will grow.
Talk to the developers building the application as to what they expect data volumes to be initially and expected growth over the next 3 to 6 months. We have no way of telling you what you need to know. We have no idea what the application is, how many users will be using the database, how much data will be entering the system over any set period of time.
July 16, 2015 at 1:32 pm
It really is a 'it depends'. If the database starts at, say 100mb, but as they load data into it it turns into 5 TB then a 100MB autogrow is too small. If the db starts at 100mb but say it only grows to 150mb then 100mb autogrow is a tad to high.
If you don't know the growth rate and cannot find anyone to answer your question I would start out at 500mb as a hip shot. Just do NOT use the percentage one use the MB growth one.
July 17, 2015 at 1:39 am
i start with 512 mb
July 17, 2015 at 11:27 am
I agree with all above, it definitely depends on how much data you have and how much you think it will grow. Don't use %s, at all, ever.
Sidebar, if you enable Instant File Initialization, it will help with any auto-grows you encounter as windows wont need to 0-out the file before it is usable, therefore making them a little quicker and not as much of a performance hit when/if you do auto-grow. I enable this on every SQL server I set up.
July 17, 2015 at 11:56 am
I agree that it depends. Some people might even suggest to disable autogrowth and set the database to the max possible size. To define the max possible size, you need to understand the other processes that might need disk space and leave them enough space.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply