Best Practice: SQL Server settings before deploying SharePoint Server 2016

Do not enable auto-create statistics on a server that hosts SQL Server and SharePoint Server. Enabling auto-create statistics is not supported for SharePoint Server. SharePoint Server configures the required settings during provisioning and upgrade. Manually enabling auto-create statistics on a SharePoint database can significantly change the execution plan of a query. We recommend updating the …

Continue reading ‘Best Practice: SQL Server settings before deploying SharePoint Server 2016’ »