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

Resolution

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

Status

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.
Egenskaper

Artikkel-ID: 3156157 – Forrige gjennomgang: 26. jul. 2016 – Revisjon: 1

Tilbakemelding