First published on TECHNET on Apr 10, 2018
First of all, these steps will be true for both SharePoint 2013 or SharePoint 2016 unless mentioned otherwise, as well the steps will be true for all supported versions of SQL unless stated otherwise.
I’m sure you realize this but let it be said SQL is the heart, brain, and body of SharePoint this means if SQL is not performing well then your users will not be happy, so here are some of the things I would recommend:
The following steps will help with performance, by are more complicated:
As a final thought remember to work closely with your DBA, they will be able to help you to get this right.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.