Tuning SQL Server 2012 for SharePoint 2013: (02) Best Practices for SQL Server Database Settings

Sign in to queue


Get ready to understand model and Tempdb database settings, database file placement, and how to determine the number of content databases. This module goes over how to modify model database to reflect configuration of new databases and configure Tempdb for improved performance, and much more.

  • [06:16] - Model and Tempdb Database Settings
  • [13:11] - Shredded Storage Demo
  • [20:24] - Modifying Model DB Settings
  • [33:39] - Database File Placement
  • [37:50] - Determining Number of Content Databases

Full course outline:



Download this episode

Download captions

The Discussion

Add Your 2 Cents