May 8, 2008 at 3:40 pm
Hi,
I am a newbie, I am in the process of creating a new database for a big application. That database is going to grow eventually. What size i should set initially (MB) and what percentage of auto file growth and the maxsize.
Thanks,
Kayal
May 8, 2008 at 3:45 pm
There's no way for us to guess this. You can search for database sizing estimates, but take a guess. Disk space is cheap, so set up something and go from there based on data growth.
May 9, 2008 at 7:48 am
You can predict the size of your database in the logical design phase of your database by calculating the size of your tables and then calculate its expected growth in future.
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 9, 2008 at 11:19 am
Remember,
Setting a good size now will prevent file fragmentation. Also, remember to spread your file groups across different physical drives if possible. Some use autogrow, I tend not to use it and when I see a database is getting close, I will add another file of appropriate size just to keep fragmentation at a minimal level.
I also recommend at least three file groups, one for the basic system objects. I normally create at least two physical files per file group on different physical drives. The system object file groups I set at 100MB each. The "User" file group is set according to data requirements, and then the last file group is a NonClustered index file group. Don't forget the logs.
Separating your log files from you data files is also a good practice.
Take an immediate full backup after you finish setting up your database.
Hope this helps
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply