Microsoft Virtual Academy content

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.

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

51 minutes, 17 seconds


Right click “Save as…”

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:


Follow the discussion

  • Oops, something didn't work.

    Getting subscription
    Subscribe to this conversation

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.