Home Forums SQLServerCentral.com Anything that is NOT about SQL! Starting a new job on Monday, and Sharepoint is involved, need suggestion on managing the SQL side. RE: Starting a new job on Monday, and Sharepoint is involved, need suggestion on managing the SQL side.

  • February 10, 2013 at 2:10 pm

    #1586325

    Add hoc workloads, maxdop and auto-update statistics (not), are a few of the configuration settings that come to mind when looking into optimizing a SQL Server for running SharePoint.

    One of the difficulties I have had with determining best settings was sorting the bad advice from the good. Just be aware of who the source of the information is. If recommendations are from a SharePoint admin or developer, then verify that advice through a trusted SQL DBA as well.

    Bret