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
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…