troubleshooting Question

Pre Creat and Pre Size SQL Databases for Sharepoint

Avatar of shockey
shockey asked on
Microsoft SharePointMicrosoft SQL Server 2008
14 Comments1 Solution810 ViewsLast Modified:
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.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 14 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros