TechEd 2013: Optimizing Microsoft SQL Server 2012 for SharePoint 2013

27 Jun
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 […]

image

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.

image

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.

Memory

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.

Slides

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

Evaluation

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

Maximilian Melcher (MCITP, MCPD) is a Managing Consultant for 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 mostly with a good coffee in his hands.
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 *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">