Improvement: Performance issue when upgrading MDS from SQL Server 2012 to 2016

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


Assume that you upgrade Microsoft SQL Server 2012 Master Data Services (MDS) to SQL Server 2016 MDS. In this scenario, you may notice that a performance issue occurs because it takes a long time to upgrade.

Resolution


This improvement is included in the following updates for SQL Server:

SQL Server 2017

Cumulative Update 7 for SQL Server 2017

SQL Server 2016

Cumulative Update 1 for SQL Server 2016 Service Pack 2

Service Pack 2 for SQL Server 2016

References


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