FIX: The “sys.dm_db_column_store_row_group_physical_stats” query runs slowly on SQL Server 2016

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


Assume that you have a server that is running SQL Server 2016. When you run the sys.dm_db_column_store_row_group_physical_stats query to search columnstore indexes in the current database, the query may take a long time to return the results.


This issue occurs because the sys.dm_db_column_store_row_group_physical_stats query does a join with the sys.column_store_segments view, which is expensive. After you install this update, this view is replaced with the syscscolsegments view to retrieve the needed information.


This update is included in Cumulative Update 1 for SQL Server 2016 Service Pack 1.


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


Learn about the terminology Microsoft uses to describe software updates.