•  

SPW08 Optimizing SQL Server 2014 for SharePoint 2013

A session at Live! 360

Wednesday 19th November, 2014

1:45pm to 3:00pm (EST)

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.

Knowing the 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 is important to understand the integration of these two products. 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 improve the performance of SharePoint. 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 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:
Understand Integration of SharePoint with SQL Server
Optimize SQL Server instance hosting SharePoint 2013 content
Implement Best Practices of SQL Server and SharePoint Integration

About the speaker

This person is speaking at this event.
Brian Alderman

International SharePoint Trainer (virtual and live), consultant, author, and speaker. Courseware development and MS certified in both SharePoint and SQL Server bio from Twitter

Sign in to add slides, notes or videos to this session

Tell your friends!

When

Time 1:45pm3:00pm EST

Date Wed 19th November 2014

Short URL

lanyrd.com/sdbtcz

View the schedule

Share

See something wrong?

Report an issue with this session