I came across this set of presentations on Channel 9 this morning and thought is was worth post. There are 4 presentations in the series each around 50 min.
Tuning SQL Server 2012 for SharePoint 2013
This session provides an overview of SQL Server deployment options and database types; understanding SQL Server and SharePoint integration, schema overview, database structure, schema restrictions and SharePoint database descriptions. Learn how to efficiently manage multiple instances on one physical server.
- [09:23] - SQL Deployment Options
- [14:55] - Database Types
- [17:18] - SQL Server/SharePoint Integration
- [29:42] - Schema Overview
- [34:35] - Database Structure
- [47:05] - SharePoint Database Descriptions
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
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
This module will show you how to avoid ginormous T-Logs by performing regular T-Log backups, how to have multiple copies of your backups, how to configure AlwaysOn for high availability and verify integrity of SQL Server databases. Lastly the instructors will cover SQL Server for SharePoint best practices.
- [03:44] - Avoiding Ginormous T-Log Files
- [23:03] - Enable SQL Server AlwaysOn
- [30:14] - Verify Integrity of Databases
- [34:58] - SQL Server for SharePoint Best Practices