Free Event: Tuning SQL Server 2012 for SharePoint 2013 Jump Start RRS feed

  • General discussion

  • 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.

    When: March 19, 2013 @ 8:00am-12:00pm PDT
    Registration: http://msl-events.cloudapp.net/EventProfile.aspx?eid=ce3d9ffb-34df-4d4e-97e2-8052f5807375&mva=true


    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

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    Twitter: @Mr_Wharty
    MC ID: Microsoft Transcript

    Monday, March 4, 2013 2:51 AM