Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Planning DB Sizes in NEW Install

  Asked By: Elton    Date: Jul 16    Category: Sharepoint    Views: 861

we are getting ready to set up our initial production SQL cluster. What are
some best practices on data structure? See if I have all the correct db(s)

Are those listed below, correct? all of them? Which will grow the most?

- SSP - one for each SharedServices<x>_db
- SSP - SharedServices<x>_Search

- SharePoint_AdminContent_db
- SharePoint_Config

- WSS_Content_db
- WSS_Content_<each web application>

- WSS_Search

Also, specific to the actual SQL setup......


1. If a content_dB should not be larger than 100G and pre-grown, does this mean
each content_db should be on its own LUN?

2. What about the log files? Should they be on their own LUN or can all log
files go together?

3. Any consideration for where the SSP db goes?

4. Any formula for calculating initial sizes to plan for? We have spec'd out
space for 1T but, no one expects anything close to that anytime soon.

5. Finally, since we know we will be small in size initially but, I've heard a
FARM can take off once word gets out, any considerations we should be worried
about that would make growing difficult later?

If I may ask those who may be involved in the BP Conference this August, is
these the kind of answers that would be covered in the talks?



3 Answers Found

Answer #1    Answered By: Shushma Zariwala     Answered On: Jul 16

You're largest databases will be your content databases and your search
database. To control the size  of your content DBs, put quotas on your Site
Collections and then limit the number of Site Collections per content db. As for
the Search db, you can generally plan  on the size being 30-40 percent the size
of the corpus of your crawled content.

Answer #2    Answered By: Bahadur Kotoky     Answered On: Jul 16

Please see the following for advise and best practices

Answer #3    Answered By: Jeremey Avery     Answered On: Jul 16

Please see the following for advise and best practices


Planning and Monitoring SQL Server Storage for SharePoint: Performance
Recommendations and Best PracticesChee

Didn't find what you were looking for? Find more on Planning DB Sizes in NEW Install Or get search suggestion and latest updates.