Tuning SQL Server 2012 for SharePoint 2013 Jump Start
Since SharePoint stores most all its data in SQL Server, it makes sense that optimizing the overall SharePoint user experience should 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 core challenge we often see is the SharePoint admin isn’t a database expert and the Database Administrator (DBA) typically isn’t familiar with the SharePoint nuances that 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 isn’t configured to optimize and protect the SharePoint environment.
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
||Bill Baer | Senior Product Marketing Manager | @williambaer
Bill is a Senior Product Marketing Manager and Microsoft Certified Master (MCM) for SharePoint in the SharePoint product group in Redmond, Washington; having previously worked at Hewlett-Packard Bill Baer has a proven background in infrastructure engineering and enterprise deployments of SharePoint Products and Technologies. While at Hewlett-Packard Bill Baer was awarded the MVP award for his contributions in the Technology Solutions Group, now known as HP Enterprise Business, which encompasses server and storage hardware, technology consulting, and software sales.
||Brian Alderman | CEO & Founder, MicroTechPoint | @brianalderman
Brian has been focused on helping IT Pros and DBAs better understand core Microsoft technologies for over 25 years. As an industry-recognized consultant, author and conference speaker, Brian’s expertise and designs range across Microsoft operating systems, Active Directory, SQL Server, and SharePoint. A frequent presenter at SharePoint Conferences around the world, he has authored or contributed to several SharePoint and other technical books, and is a MCSE, MCT, and MCDBA. Brian has a BS and MS in Computer Information Systems where he graduated summa cum laude from Regis University of Colorado Springs and lives in Scottsdale, AZ where he enjoys playing golf year round and traveling around the world.