FIX: Add CXPACKET wait type in showplan XML in SQL Server 2016 and 2017

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

Symptoms


When you look in the sys.dm_os_wait_stats view or other dynamic management views (DMVs) in SQL Server 2017 and Microsoft SQL Server 2016, you may find the CXPACKET wait type. However, when you capture the execution plan (showplan XML) for queries, you find that the CXPACKET wait isn't included.

For more information about CXPACKET waits, see sys.dm_os_wait_stats.

Resolution


Cumulative Update Information for SQL Server:

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

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

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.