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
Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates 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.

Article ID: 3156157 - Last Review: 07/26/2016 08:39:00 - Revision: 6.0

Microsoft SQL Server 2014 Service Pack 1

  • kbqfe kbsurveynew kbfix kbexpertiseadvanced KB3156157