Geeks With Blogs
Deepak Puri
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.


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.
Posted on Sunday, March 3, 2013 11:38 AM Sql Server , SharePoint , Focus groups & Engagements | Back to top

Comments on this post: Tuning Sql Server 2012 & SharePoint 2013 (MVA)

comments powered by Disqus

Copyright © deepakpuri | Powered by: