FIX: Processor group affinity issues in SQL Server 2016 Analysis Services (Tabular mode)

Symptoms

When you use a Tabular instance of Microsoft SQL Server 2016 Analysis Services on a computer that has multiple processor groups, you may experience one or more of the following issues:
  • The group affinity settings for the Analysis Services (Tabular mode) threads are not logged in Msmdsrv.log.
  • Analysis Services (Tabular mode) can use only the processors in the first processor group regardless of the configuration in the Msmdsrv.ini file.
  • The limit on the number of cores that can be used by a specific edition of Analysis Services (Tabular mode) is not correctly implemented.


Resolution

The issue was first fixed in the following cumulative update of SQL Server:
Recommendation: Install the latest cumulative update for SQL Server

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

Article ID: 3168242 - Last Review: Jul 26, 2016 - Revision: 1

Microsoft SQL Server 2016 Developer, Microsoft SQL Server 2016 Enterprise, Microsoft SQL Server 2016 Enterprise Core

Feedback