Improvement: Performance improvement for "sequence point algorithm" step in SSAS 2016 Tabular Model transactions

Ισχύει για: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you are using a Microsoft SQL Server 2016 Analysis Services (SSAS 2016) Tabular model with compatibility mode 1200 that contains a lot of measures. In this situation, you may find that the "sequence point algorithm" step of a transaction may take a long time to complete.

Resolution


A performance improvement for the "sequence point algorithm" step was introduced in the following cumulative update for SQL Server:

       Cumulative Update 2 for SQL Server 2016 SP1

 

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.