locked
SQL Server 2008 R2 File Groups to help SharePoint performance? RRS feed

  • Question

  • Hi SQL Server community,

    I have a SharePoint 2010 content database (SQL Server DB) that is slow for end users- meaning they are working with a few large lists in SharePoint, containing a lot of columns and they are filtering on a lot of views they have created. This is all just generally slow for them.

    I am wondering if adding a file group to this content DB would improve things?

    Mike

    Thursday, April 28, 2011 11:14 PM

Answers

  • Hi,

    You may need to idenitty where the performance bottleneck comes from. If it is defined as IO subsystem, you may be able to improve performance via adding additional filegroups/files. However, you may also have very bad fragment indexes, therefore rebuilding or reorag can be performed as well. To troubleshoot SQL Server performance issues, you can use waits and queues method mentioned in the following Books Online docunentation: http://msdn.microsoft.com/en-us/library/ff647793.aspx.

    Meanwhile, since this is a SharePoing 2010 content database, you can invovle SharePoint experts looking into this issue as well.

    Hope this helps. 


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Thursday, May 5, 2011 8:34 AM
    Monday, May 2, 2011 5:47 AM

All replies

  • Mike

    Generally MS has advised to not touch those databases

    http://dimantdatabasesolutions.blogspot.com/2008/06/how-do-you-maintain-sharepoint.html


    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Sunday, May 1, 2011 6:38 AM
  • Hi,

    You may need to idenitty where the performance bottleneck comes from. If it is defined as IO subsystem, you may be able to improve performance via adding additional filegroups/files. However, you may also have very bad fragment indexes, therefore rebuilding or reorag can be performed as well. To troubleshoot SQL Server performance issues, you can use waits and queues method mentioned in the following Books Online docunentation: http://msdn.microsoft.com/en-us/library/ff647793.aspx.

    Meanwhile, since this is a SharePoing 2010 content database, you can invovle SharePoint experts looking into this issue as well.

    Hope this helps. 


    Best Regards,
    Chunsong Feng

    Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    • Marked as answer by WeiLin Qiao Thursday, May 5, 2011 8:34 AM
    Monday, May 2, 2011 5:47 AM