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!
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
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: https://collab365.community/page/maximizing-sql-2012-performance-for-sharepoint.