SharePoint On-Premises Infrastructure Management and Administration

OST03 Optimizing SQL Server for SharePoint

12/06/2016

11:00am - 12:15pm

Level: Intermediate to Advanced

Brian Alderman

Microsoft MVP, MCT

Consultant, Speaker, Author

MicroTechPoint

The vast majority of the content accessed via SharePoint is stored in SQL Server. An incorrect configuration of SQL Server can have a detrimental impact on SharePoint performance, so it's important to understand the integration of these two products. DBAs are often familiar with how to manage SQL Server, but may not be familiar with some its nuances when integrated with SharePoint. This session will demonstrate how some default SQL Server settings can have a negative impact on SharePoint and what changes can be made in SQL Server at both the instance and database level to improve the performance of SharePoint. You'll learn the Best Practices framework that will help you configure SharePoint and SQL Server to provide optimal performance for your SharePoint.

You will learn:

  • How SQL Server integrates with SharePoint
  • SQL Server instance configurations for optimization
  • SQL Server database configurations for optimization