SharePoint
stores most of its data in SQL Server, optimizing the overall SharePoint user
experience has focus on how these products are integrated. During this Jump
Start, two of the industry’s most popular SharePoint experts,Bill
Baer and Brian Alderman, lead a
demo-rich exploration of SQL Server settings, SQL Server system database
settings and configuration options that will improve SharePoint 2013
performance, availability and security.
A common
scenario often seen is the SharePoint admin is not a database expert and the
Database Administrator (DBA) typically is not familiar with SharePoint features
which require adjustments in SQL Server. Similarly, in smaller organizations
one person serves both roles. In all these cases, the result is most likely a
SQL Server 2012 deployment that is not configured to optimize and protect the
SharePoint environment.
Tuning SQL Server 2012 for SharePoint
2013 Jump Start
Date: March 19, 2013
Time: 8:00am – 12:00pm
PDT
Where: Live, MVA online
virtual classroom
Cost: FREE!
Register here.
COURSE OUTLINE
01 | Key SQL Server and SharePoint Server Integration Concepts (50
minutes)
• Dedicated Server or Instance; SQL Database and
database files
• ldf to mdf checkpoint process; Recovery model (Simple
vs. Full)
02 | Best Practices: SQL Server Database Settings (50 minutes)
• Model Database; TempDB (Location)
• Initial size, Autogrowth, and Collation; Recovery
model
03 | Server Settings for SQL Server (50 minutes)
• Default Database File Locations
• Memory Settings; MAXDOP
04 | SQL Server and SharePoint availability (50 minutes)
• Avoiding large log files; Backups and Location of
Backups
• SQL Server 2012 AlwaysOn; Best Practices
Have fun People and see you online :)
For those of you who missed it, you can watch the videos here.