Forum Discussion

Speedomaz21's avatar
Speedomaz21
Copper Contributor
Nov 15, 2021

Cannot SET AUTO_UPDATE_STATISTICS and AUTO_UPDATE_STATISTICS_ASYNC status to FALSE.

Hi,

Have been using SharePoint 2016 with SQL Server 2016. For compliance issues, we need to set 

SET AUTO_UPDATE_STATISTICS and AUTO_UPDATE_STATISTICS_ASYNC status to False. 

Whenever we set to false its automatically back to True after certain time. We don't have any SQL Server Agent Jobs running.

 

My DBA suspect this could be due to some hardening settings at SharePoint. If anyone knows the solution, Please advise how to resolve.

No RepliesBe the first to reply

Resources