Update to improve the performance for columnstore dynamic management views "column_store_row_groups" and "dm_db_column_store_row_group_physical_stats" in SQL Server 2016 or 2017

Applies to: SQL Server 2016 Enterprise CoreSQL Server 2016 EnterpriseSQL Server 2016 Developer

Symptoms


This update improves the performance for columnstore Dynamic Management Views (DMV) column_store_row_groups and dm_db_column_store_row_group_physical_stats in SQL Server 2016 or 2017. After you install this update, the DMV execution might take less time to complete, and less memory is used.

Resolution


This fix is included in the following updates:

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 Microsoft uses to describe software updates.