Pre Creat and Pre Size SQL Databases for Sharepoint
Posted on 2009-12-17
I need to get some clarification regarding the pre-creating and pre-sizing of the SQL databases for SharePoint. Many online documents reference that you should pre-create the databases and pre-size them, such as the content db's. they also mention that you should pre-size the tempdb. However, I need some clarification regarding the sizing process. For example, if I pre-size all of my content db's to be 100GB (which is the max I plan to have per DB, based on MS recommendations), but then these references say that you should have multiple data files per DB and they recommend 4-8 datafiles if the physical server has 8 processors, which it does. They then provide a formula for determining the file size per datafile and in this equation they say to take the max db size and multiple by .25 then divide for the number of datafiles. Here is where I am confused, with this formula I would have (4) datafiles of size 6.25GB each, for a total of 25GB, but it seems to me that they need to equal 100GB if that is what I am pre-sizing the db to. I need some clarification on this process from some of you SQL/Sharepoint guys out there. Thanks.