Running multiple UPDATE STATISTICS for different statistics on a single table concurrently is available


Cumulative Update information

To enable this feature improvement, enable the SQL Server trace flag 7471.
Trace flag 7471 is a global trace flag and can be specified as a startup parameter by using the dbcc traceon (7471,-1) or the -T7471 option in the command line argument.

This feature improvement was first introduced in the following cumulative update of SQL Server. 
Recommendation: Install the latest cumulative update for SQL Server


Microsoft supports this feature enhancement in the Microsoft products that are listed in the "Applies to" section.

For additional information about this enhancement, review the Boosting Update Statistics performance with SQL 2014 SP1/CU6 on MSDN.

Ідентифікатор статті: 3156157 – останній перегляд: 26 лип. 2016 р. – виправлення: 1

Зворотний зв’язок