FIX: Query against sys.dm_db_partition_stats DMV runs slow if the database contains large numbers of columnstore partitions in SQL Server 2016

Applies to: SQL Server 2016 DeveloperSQL Server 2016 EnterpriseSQL Server 2016 Enterprise Core

Symptoms


Assume that you use Microsoft SQL Server 2016. When you query against sys.dm_db_partition_stats Dynamic Management View (DMV) on a database that contains large numbers of columnstore partitions, the query might take a long time to complete.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:

       Cumulative Update 6 for SQL Server 2016 RTM

       Cumulative Update 3 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.