FIX: Deadlock when you use sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats DMV with large DDL operations in SQL Server 2016

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


When you use the sys.column_store_row_groups and sys.dm_db_column_store_row_group_physical_stats dynamic management views (DMV) together with large data definition language (DDL) operations in Microsoft SQL Server 2016, a deadlock may occur.


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

       Cumulative Update 6 for SQL Server 2016 RTM

       Cumulative Update 4 for SQL Server 2016 SP1



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


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