It is recommended to disable the AUTO_UPDATE_STATISTICS_ASYNC option when your SQL Server executes operations that significantly change the distribution of your data, like truncating a table or running bulk updates on a large percentage of the rows. Because it uses stale execution plans and leads to performance issues when we have bulk updates on the table.
selectstarfromyogi 