Roger Haueter

Modern Workplace Strategist | Microsoft Most Valuable Professional

SQL Server Best Practices for SharePoint Server 2016

The performance of SharePoint Server 2016 is heavily dependent on SQL Server. In this article I'm going to show you how to configure SQL Server optimally and how to improve the performance of a SharePoint platform overall.

Almost all SharePoint data is stored in SQL Server. Because of this fact it's not surprising that the SQL Server performance has a direct impact on the speed of SharePoint. Below are a few tips to improve performance at no extra cost.

Configuration at Windows Server level

Windows Server Performance Options
By default Let Windows choose what's best for my computer is set. In most cases, the server is optimized for a nice display, but this is not very important for a server. The value can be set to Adjust for best performance:
Right-click on This PC> Properties > Advanced System Settings > Advanced > Performance > Settings... > Visual Effects
2013-04-02_125748

Set Page File Size
By default, the page file is managed by Windows. In most cases, it makes sense to determine the size and storage location yourself.
This PC > Properties > Advanced system settings > Advanced > Performance > Settings... > Advanced > Virtual Memory > Change...Read more


Important SharePoint directories explained

A brief overview of all important SharePoint 2016 directories and their functionality. All of these directories must be backed up so that SharePoint can be completely restored at file level in the event of a disaster. Don't forget to backup the directories containing data from 3rd party applications.

C:\Program Files\Microsoft Office Servers\16.0
Default directory for binaries and data from SharePoint 2016.

C:\Program Files\Microsoft Office Servers\16.0\Data
Root directory for local data and search indexes.

C:\Program Files\Microsoft Office Servers\16.0\Logs
Default directory for Run-Time Diagnostic Logfiles.

C:\Program Files\Microsoft Office Servers\16.0\WebServices
Root directory for SharePoint back-end Web services such as search or Excel services.

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16
Installation directory for the Core SharePoint files.

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\16\ADMISAPI
This directory contains the soap services for the central administration.
Read more


SharePoint 2016 Cumulative Updates: January 2018

The January 2018 Cumulative Updates contain fixes and improvements for SharePoint Server 2016 and Office Online Server 2016.

Installation instructions

  • Create a SharePoint Farm Backup.
  • Download all SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm.

Update KB4011642 for SharePoint Server 2016: January 9, 2018
This fix contains updates for language-independend files. It also updates the configuration database schema and the SharePoint build number.
Download
Description of the SharePoint Server 2016 update package
Read more


SharePoint 2013 Cumulative Updates: January 2018

The January 2018 Cumulative Updates contain numerous hotfixes and improvements for SharePoint Foundation 2013, SharePoint Server 2013, Project Server 2013 and Office Web Apps Server 2013. The cumulative update package is multilingual and contains updates for all languages.

Before you start
Since June 2014 the Cumulative Updates for SharePoint products releases on a monthly basis.
Since May 2015 the server proofing tools are included in the cumulative updates.
This cumulative update includes all patches since the Service Pack 1 release, but not the Service Pack 1 itself. You must install the Service Pack 1 before installing this cumulative update. Read how-to install Service Pack 1.
Because of the file size the cumulative update package has been divided in three parts; ubersrv.exe, ubersrv_1.cab and ubersrv_2.cab. You have to put them all in the same folder.

Installation instructions

  • Create a SharePoint Farm Backup.
  • Download all SharePoint Foundation and SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm. This step is required if your farm level is lower than July 2015 CU.
  • Restart the User Profile Service on affected servers.

Hotfix KB4011649 for SharePoint Foundation 2013: January 9, 2018
Download
Description of the SharePoint Foundation 2013 update package
Read more


SharePoint 2010 Cumulative Updates: January 2018

The January 2018 Cumulative Updates contain numerous hotfixes and improvements for SharePoint Server 2010 and Project Server 2010. The cumulative update package is multilingual and contains updates for all languages.

Before you start
Since June 2014 the Cumulative Updates for SharePoint products releases on a monthly basis!
Be aware that the cumulative update requires the Service Pack 2 to be installed. This Cumulative Update does not support Service Pack 1. The SharePoint Server 2010 cumulative update contains all resources of SharePoint Foundation 2010 since the release of Service Pack 2.

Installation instructions

  • Make sure you already installed and configured the Service Pack 2.
  • Create a SharePoint Farm Backup.
  • Download all SharePoint Foundation and SharePoint Server packages.
  • Extract the previously downloaded files with a double-click.
  • Click "Continue"
  • Define the path in which you would like to extract the installation binaries and click OK. Use the same destination path for the other files.
  • Run the extracted EXE file as administrator.
  • Accept the license terms and click "Continue".
  • Repeat the previous two steps for the other EXE files in this folder.
  • Apply the updates to each SharePoint server in the farm.
  • As soon as the installation of the cumulative update has finished on all servers, run the SharePoint Configuration Wizard successively on each SharePoint server in the farm.
  • Restart the User Profile Service on affected servers.

Hotfix KB3141547 for SharePoint Foundation 2010: January 9, 2018
Download
Description of the SharePoint Foundation 2010 update package

Read more