As a DBA, I am trying to do some capacity planning for sharepoint 2007 dbs. We will have a large site of 2+TB and I am trying to get an idea of what sizes to expect once the DBs grow to full size. The database types are Content (multiple), Sharedcontent, Search, SharedSearch, AdminContent, and Config.
Can anyone offer any advice. Any advice on what type of activity to expect from each of these databases would also be appreciated.
Thanks!
Capacity Planning Sharepoint 2007 DBs
drew_p
dba72,
There are no hard and fast rules on this and you will need to work with the SharePoint administrators to ensure your site collection content databases are managable.
These two posts by Joel Oleson provide a good start point.
http://blogs.msdn.com/joelo/archive/2007/01/31/tips-on-site-collection-sizing.aspx
http://blogs.msdn.com/joelo/archive/2006/12/01/perf-and-sizing-data-from-msw-enterprise-search.aspx
HTH
Andrew