FIX: CXPACKET and CXCONSUMER wait types show inconsistent results for some parallel query plans in SQL Server 2016 and 2017

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


Assume that you use Microsoft SQL Server 2016 and 2017. When you query the dynamic management views (DMV's) sys.dm_exec_session_wait_stats and sys.dm_os_wait_stats, you may see inconsistent results for wait types CXPACKET and CXCONSUMER for some parallel query plans.

The same inconsistency can also be found between sys.dm_os_wait_stats and the wait stats in an Actual Execution Plan.


This issue is fixed in the following cumulative update and service pack for SQL Server:

       Cumulative Update 4 for SQL Server 2017

Service pack information for SQL Server 2016

This issue is fixed in the following service pack for SQL Server:

       Service Pack 2 for SQL Server 2016


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.