Free Whitepaper: Maximizing SQL 2012 Performance for SharePoint 2013 Whitepaper

Hello Everyone,

As promised in the teaser last week, my free Whitepaper about maximizing SQL 2012 Performance for SharePoint 2013 is out and it's a SharePoint-Community.Net exclusive for 1 week!  Here is the abstract! 

Abstract


As a SharePoint Consultant I get to see dozens of SharePoint farms every year, and one of the most
common complaints I get from clients - is that SharePoint is slow. A lot of people think that SharePoint is
slow because the SharePoint servers are lacking resources or, simply, because SharePoint is a slow
product. Although resources allocated to the SharePoint servers (e.g. Web Front Ends and App servers)
are important, not a lot of people realize that SharePoint performance is directly related to the
database, SQL Server. In fact, 94% of SharePoint data is stored in SQL1
.
In this whitepaper, we will explore many options on how to optimize SQL Server 2012 for SharePoint
2013. Here is a high level overview of what we intend to explore.


1. Plan before you install
In this section we will review important best practices on how to format your disks, as well as
how to plan where databases, logs and your Temp DB will be located. Furthermore, depending
on the purpose of your SharePoint 2013 Farm, we will determine which databases are most
important.


2.How to install SQL Server 2012
In this section we will discuss what changes during installation can impact SQL 2012 Server
performance and explain the reasons behind them. For example, did you know SharePoint 2013
uses a different collation than the default SQL one?


3. Post installation changes
In this section we will examine the changes required immediately after you have installed SQL
2012. This will ensure that we have the correct settings from the outset. We will cover
everything from Initial DB size to Fill Factor to Instant File Initialization.


4.How to keep it performing well for the years to come
Now that you installed SharePoint 2013, Web Applications are starting to be created, content is
added. Unfortunately, if you want to keep your SharePoint fast and your users happy, your job is
not done. In this section we will make a list of things you need to check and modify, together
with a schedule. Luckily, since we made things right in the Post Installation changes, you won’t
have to do them very often.

 You can download it here:  http://sharepoint-community.net/page/maximizing-sql-2012-performanc...

Views: 2758

Tags: IT-Pro, SharePoint-Community

Comment by Mark Jones on April 22, 2013 at 13:50

Thanks for sharing this Vlad (free as well), I personally know how long you took to put this together, and it wasnt' a quick thing! This is what the community and sharing is all about! Thanks.

Comment by Jesper M. Christensen on April 23, 2013 at 6:34

Yeah, really great job you did there. Also for making sure that you have back-up from Microsoft Technet articles for the advice - and proving this Works on a lab-environment.

This whitepaper gathers a lot of advice spread all over the internet and conferences - a must read for SharePoint administrators and SQL Admins aswell.

Comment by Gokan Ozcifci on April 23, 2013 at 8:57

Thanks Vlad! great work !

Comment by Eric Moore on April 23, 2013 at 22:42

Thank you for sharing.

Comment by Sébastien Levert on April 24, 2013 at 4:30

Looks like a must-have for any SharePoint admin ! Nice work Vlad !

Comment by Henry Phillips on April 24, 2013 at 10:56

Very interesting read indeed. In fact I find this area of a SharePoint implementation greatly overlooked and as you say the majority of SharePoint content is stored in Databases. I will certainly be following these guidlines and others I have read as a priority in any future SharePoint implementations.

Comment by Vlad Catrinescu on April 24, 2013 at 11:23

Thanks everyone! You guys rock! :)

Comment by Philippe NONORGUES on May 29, 2013 at 13:53

Thank you for this document. It help me for a perfect setting of sql server.

Comment by Vlad Catrinescu on May 29, 2013 at 13:54

I am Really happy you liked it! 

Comment by Prasad kasireddy on March 26, 2014 at 6:27

thank you for sharing !!

Add a Comment

You need to be a member of SharePoint Community to add comments!

Join SharePoint Community

© 2014   Created by Mark Jones.   Powered by

Badges  |  Report an Issue  |  Terms of Service

Live Support