Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SharePoint uses a single table (i.e. dbo.AllUserData) with columns like nvarchar1, nvarchar2, ..., nvarchar64 or int1, int2, ..., int16 (193 columns altogether) to store all items from all lists in all site collections.

  • Can creating new indexes, recomputing statistics, etc. help?
    Let's forget for now that it very likely to lose Microsoft support for SharePoint installation modified like this.

  • Am I right in thinking that such a design makes all classic databases tuning techniques useless?

  • Has anyone ever tried to solve performance problems of SharePoint in any other way than adding more/faster hardware?

share|improve this question
    
Its a content database or custom database ? –  Muthukkumaran Kaliyamoorthy Feb 16 '11 at 14:38
    
@Muthukkumaran Kaliyamoorthy Out-of-the-box SharePoint content database. –  Marek Grzenkowicz Feb 16 '11 at 15:54
add comment

1 Answer 1

up vote 7 down vote accepted

There is not a lot you can do to tune the database it self. You aren't allowed to create indexes, or statistics.

Keep your content databases small. If they get to 100 Gigs you'll want to add another content database (there's ways to do this through the SharePoint UI).

As the tables grow you will want to be sure that you are doing index rebuilds and updating stats regularly.

You can look at using the EBS feature if you are using SharePoint 2010 (might be in SharePoint 2007 as well) which will allow you to move the blob data out of the database and store it on the file system using SQL Server's FILESTREAM feature.

Short of that there isn't much you can do besides throwing more hardware at the problem.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.