November 29, 2013 at 6:30 am
Dear All,
I wanted to create some databases but I wanted to know how to determine how much file frowth to specify in MB please?
Thank you in advance.
November 29, 2013 at 10:02 am
tt-615680 (11/29/2013)
Dear All,I wanted to create some databases but I wanted to know how to determine how much file frowth to specify in MB please?
Thank you in advance.
If you have disk space then don't rely on growth, set the initial size already big...
File growth depends on how much your database will increase, daily, monthly, ....
Every time the database grows it's an extra IO (be sure to have the SQL Server process user in the group policy Perform large volume operations to allow instant file initialization).
Usually I set my databases to grow no more than 500MB every time, but the databases have 5G or more.
For databases smaller than 1GB I set it to 100MB but be carefull and check if a "single" operation can make the database grow more than that..
Pedro
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply