Dealign with a large SharePoint 2010 content database

Posted on 2013-10-14
Medium Priority
Last Modified: 2013-11-01
I have a content database that's nearly 200GB (SharePoint 2010 with the content DB hosted on a separate SQL 2008 Server, DB is called WSS_Content).

Here's the output of STSADM -o enumsites -url http://mySPSite

<Sites Count="22">
  <Site Url="http://mySPSite"  ContentDatabase="WSS_Content" StorageUsedMB="177452.6" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/mysites" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.9" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user1"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user2"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.9" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user3"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user4"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="50.1" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user5"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user6"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="449.9" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user7"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user8"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="75.6" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user9"  ContentDatabase="WSS_Content_MySites" StorageUsedMB="5.7" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user10" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user11" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user12" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user13" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user14" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user15" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user16" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user17" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user18" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/personal/mySP_user19" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1.8" StorageWarningMB="0" StorageMaxMB="0" />
  <Site Url="http://mySPSite/sites/Office_Viewing_Service_Cache" Id="acc28147-6948-4f2e-a4ce-33b607256e84" Owner="mySP\spsetup" ContentDatabase="WSS_Content_MySites" StorageUsedMB="1128.7" StorageWarningMB="0" StorageMaxMB="102400" />

I have a few questions on this:
1. What's the process to make it smaller?
2. What content should I split out? The one site collection http://mySPSite is really big (177GB), there a way to somehow break that up without significantly restructuring our SharePoint environment?

Question by:Julian123
  • 4
  • 3
  • 2
  • +1

Expert Comment

ID: 39573025
Easiest would be to create additonal content databases and move sites (import/export) to the new databases.

Once a site is moved the whitespace within the original content database is not cleaned up/reduced though.

Once I have moved all sites from the original and verified that it is clean, I usually re-create it and new sites will homed on it..
LVL 13

Expert Comment

by:Yagya Shree
ID: 39573715
I would recommend to run powershell command on the one site with 177 GB content and first check out if this is actual content or some unwanted files filling space.

As i have seen users deleting content regularly and then keeping their recycle bin full.

Once i identify which specific location in the site is using most of the space, you can move that site out of content database and create a new one for the same.

So identification and cleanup of the site using high volumn should be first task.

hope that helps.

Expert Comment

ID: 39573743
@ yagyashree

"Once i identify which specific location in the site is using most of the space, you can move that site out of content database and create a new one for the same."

Could you please eloborate on the underlined, is the new site created within the original content database or a new content database..
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

LVL 13

Expert Comment

by:Yagya Shree
ID: 39573822
New content database
LVL 12

Author Comment

ID: 39575437
Thanks for the help. In terms of moving sites to the new content database, a few questions:
1. At what level can I move sites? My site http://mySPSite has 177GB, can I move, say just http://mySPSite/big_sub_site1 to a new content DB and keep http://mySPSite/big_sub_site2 in the existing content DB?
2. If I do #1, will the user experience change at all?
2. What's the process for moving the sites?
3. Per the mention above of whitespace in the DB, how do I resolve that? Is there a way to shrink the DB?

LVL 13

Expert Comment

by:Yagya Shree
ID: 39576049
1. Yes, you can move subsite1 from your site collection to new site collection and keep your subsite2
2. You would need to be careful while doing this as URL of the site would change for subsite user who content would be moved to new site collection. Also you need to make sure any customization your done on source site collection need to be done on destination site collection as well
3.you can use powershell, STSADM or any third party tool like Metalogix to perform the action
4. Once the content is moved  you can perform a db shrink to recover free space.

Hope this helps.
LVL 12

Author Comment

ID: 39576080
Thanks, yagyashree. Concerning your answer #2 above, if I moved http://mySPSite/big_sub_site1 to a new content DB , you mentioned the URL would change.  Would I need to make any changes to the sites still in the old content DB ( the main http://mySPSite or http://mySPSite/big_sub_site2, a sub-site not moved) for site navigation to still work?

Would the moved site now be something like http://mySPSite_2/big_sub_site2?
LVL 13

Expert Comment

by:Yagya Shree
ID: 39576100
No changes are required in old site collection or subsite.

When you move the subsite to detination, the new site will read as http://myspsite_2 as the move will on the top level of the site

Note: make sure you take DB backup before activity and keep it till you get user's confirmation that all is working well.
LVL 12

Author Comment

ID: 39584251
Thanks. If I have links on the http://myspsite/ page that pointed to  http://mySPSite/big_sub_site1 and then I move that subsite to a new content DB, it sounds like that site's url would now be  http://mySPSite2/big_sub_site1. Would the links on the http://myspsite/ page that pointed to the old url now be broken? Or would those get fixed automatically?
LVL 38

Accepted Solution

Justin Smith earned 2000 total points
ID: 39605532
Splitting a site collection up is never a good idea.  All subsites in a site collection should be kept together.  Reason being, the subsites have dependencies on the root site in the site collection.  While it can be done, it's not a good idea.

All links would in fact be broken.  You can't fix them automatically other than developing a script to do it.

A better idea would be to clean up the site if it has unnecessary data.  Or move this site collection "http://myspsite" to it's own content database.  THis is accomplished by using the Move-SPSite command.

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…
Suggested Courses

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question