Tuning SQL Server 2012 for SharePoint 2013: (03) Server Settings for SQL Server
- Posted: Mar 20, 2013 at 7:29PM
- 22,221 views
This video is part of a free online course from Microsoft Virtual Academy, click here to view the full course and take advantage of many additional features such as assessments, slides, learning plans and more.
Right click “Save as…”
In this segment you will learn how to modify memory settings to control memory usage by SQL Server, how to change default file locations, how to leave MAXDOP at 1 for SharePoint and how to verify operating system set to 64KB allocation unit size. Get ready for some great demos and rich dialogue.
Full course outline: