TechEd 2013: Optimizing Microsoft SQL Server 2012 for SharePoint 2013

27 Jun 2013
June 27, 2013

If SQL Server does not perform, SharePoint can not show its full potential – to quote the session description:

More than 90% of the content accessed via SharePoint is stored in SQL Server and without the correct configuration of SQL Server it can have a detrimental impact on the performance of SharePoint. Regardless of whether you have a dedicated DBA or the SharePoint administrator is also the DBA there are critical SQL Server configurations that can be made that will optimize SharePoint […]


Here are my session about the session by Brian Alderman (@brianalderman)

Database Overview and Recommendations

Database limit was increased,  still 200GB is recommended. Separate instance for SharePoint is Best Practice.

Instance defaults:

  • During installation set the default Collation to Latin1_CI_AS_KS_WS
  • Set the default location to something different than c: drive

Set the default grow sizes to per MB instead of percent growth rate. If your database grows instantly by 20GB it’s a performance degradation for a while. Set it to a reasonable amount.

Split the content db and the log file if possible – different drives, more performance.


Plan Site Collections

Important: If you want to stay below the 200GB limit you have to calculate the site collection bin size into amount. Good reminder. Additionally set quota templates.


SQL Server is memory hungry – set a reasonable minimum and maximum memory. Example: 25GB minimum and 30GB maximum. In the rare cases that SQL Server releases the memory you don’t drop below 25GB. But that does not mean it claims the 25GB upfront.


Grab the slides (once they are available), definitely worth reading!


I like the topic, its very important for good performance. The hints from Brian covered so many areas, great! I wish he had a PowerShell repository how to set many of them automatically. Still, a very valuable session!

Brian in action!

Brian in action!

Max Melcher
Follow me!

Max Melcher

Maximilian Melcher (MCSE, MCPD) is a Principal Consultant working at Alegri International Services in Munich, Germany. Max is a specialist in SharePoint technologies focused on search, social computing, web content management and collaboration. Max has led SharePoint implementations for Dax 30 companies since 2009.
Max’s free time is spent on twitter (@maxmelcher) mostly with a good coffee in his hands.
Max Melcher
Follow me!
Tags: , ,
1 reply

Trackbacks & Pingbacks

  1. […] MS TechEd Europe in MadridDan Holme talked about SP2013 and Office365 upgrade and migration strategies, Session notes by Max MelcherCorey Burke and Todd Klindt talked about Administration, session notes by Max Melcher (incl further links)IaaS: Hosting SharePoint on Azure, session notes by MaxSharePoint 2013 Search Development by my Norwegian colleague Jan Inge Bergseth, session notes by MaxOptimizing SQL Server 2012 for SP2013 by Brian Alderman. Guess how made great session notes again? Kudos to Max […]

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.