Tuning SQL Server 2012 for SharePoint 2013: (03) Server Settings for SQL Server

Download

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.

  • [05:06] - SQL Server Instance Settings
  • [15:09] - Modifying SQL Memory Settings
  • [24:44] - Operating System Settings

Full course outline:

Tags:

Follow the Discussion

Comments Closed

Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.