Friday 1:50 PM - 3:00 PM · Room S106a

Optimizing SQL Server for SharePoint Server

Brian Alderman

Microsoft MCT, Six-Year MVP, Author, Speaker, and Consultant

A vast majority of the content accessed via SharePoint is stored in SQL Server, and also knowing an incorrect configuration of SQL Server can have a detrimental impact on the performance of SharePoint it is important to understand the integration of these two products. Often DBA’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 in SQL Server at both the instance and database level to improve the performance of SharePoint.

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.