1 / 15

Tuning SQL Server for SharePoint Jump Start

Tuning SQL Server for SharePoint Jump Start. Bill Baer | Senior Product Marketing Manager, Microsoft Brian Alderman | Chief Executive Officer | MicroTechPoint. Course Topics. Module Agenda. Model & Tempdb Database Settings Database File Placement Determining Number of Content Databases.

minda
Download Presentation

Tuning SQL Server for SharePoint Jump Start

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tuning SQL Server for SharePoint Jump Start Bill Baer | Senior Product Marketing Manager, Microsoft Brian Alderman | Chief Executive Officer | MicroTechPoint

  2. Course Topics

  3. Module Agenda • Model & Tempdb Database Settings • Database File Placement • Determining Number of Content Databases

  4. Model & Tempdb Database Settings

  5. Model System Database Settings • Increase Initial Size Setting • Increase Autogrowth Settings (Use MB Not %) • Cannot Modify Collation on Model DB • Use Full Recovery Model

  6. Full Recovery Model Content Database Located on Hard Drive .MDF .LDF Data Data Add Content Checkpoint Data Data Full Recovery Model (Recommended)

  7. Simple Recovery Model Content Database Located on Hard Drive .MDF .LDF Data Add Content Checkpoint Data Simple Recovery Model

  8. Tempdb System Database Settings • Configure Tempdb Data Files = No of Proc. Cores • Configure Tempdb Size • At Least 10% of Total Content DB’s Size or • Size of Largest Table - Whichever Greater • Tempdb Database Settings • Increase Initial Size Setting • Increase Autogrowth Settings (Use MB Not %) • Use Simple Recovery Model • Place on Different Drive Than Content Databases

  9. Modifying Model DB SettingsCreating Additional Databases

  10. Database File Placement Determining Number of Databases

  11. Recommended Database File Placement • Priority (Fastest to Slowest Drive) • Tempdb Data and Transaction Log Files • DataBase Transaction Log Files • Search Database Data Files • Content Database Data Files • Use Multiple Data Files for Content and Search DB’s • Distribute Equally-Sized Data Files Across Separate Disks • Number of Data Files Should Be <= Number of Processor Cores • Multiple Data Files Not Supported for Other DBs

  12. Planning Site Collections and DatabasesNeed 800 Site Collections at 500MB Each Web Application 200GB 200GB 200GB 200GB 250 250 250 250 Site Collection Site Collection Site Collection Site Collection HR Sites Student Sites Projects Sites Sales Sites

  13. Configuring Content Databases

  14. Summary • Modify Model Database to Reflect Configuration of New Databases • Configure Tempdb for Improve Performance • Place Database Files on Recommended Drives • Control Size of Databases Using Quota Templates and Maximum Site Collection per Database Setting

More Related