SPW06 Optimizing SQL Server 2012 for SharePoint 2013


11:00am - 12:15pm

Level: Intermediate to Advanced

Brian Alderman

Microsoft MVP, MCT

Consultant, Speaker, Author


More than 90% of the content accessed via SharePoint is stored in SQL Server and without the correct configuration of SQL Server it can have a detrimental impact on the performance of SharePoint. Regardless of whether you have a dedicated DBA or the SharePoint administrator is also the DBA there are critical SQL Server configurations that can be made that will optimize SharePoint. Often DB's are familiar with how to manage SQL Server, but may not be familiar with some nuances that SQL Server has when integrated with SharePoint. In this session we will demonstrate how some default SQL Server settings negatively impact SharePoint and what changes can be made to improve the performance of SharePoint. These changes include database file settings and SQL Server instance settings. We'll also examine how to properly install SQL Server and SharePoint so they work together as efficiently as possible. This discussion will introduce the Best Practices framework that will allow your SharePoint administrator and/or your DBA to configure SharePoint and SQL Server to provide optimal performance for your SharePoint implementation.

You will learn:

  • Optimized SharePoint 2013 when Creating and Configuring SQL Server 2012
  • Configure SQL Server 2012 Instance Level Settings to Improve SQL Server and SharePoint Performance
  • Configure SQL Server 2012 Database Level Settings to Improve SQL Server and SharePoint Performance