FIX: Assertion error occurs when you use sys.dm_exec_query_statistics_xml in SQL Server 2016

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

Symptoms


Assume that you use the Dynamic Management Functions (DMF) sys.dm_exec_query_statistics_xml in Microsoft SQL Server 2016. When the query that is executed in the targeted session ID uses a Large Object (LOB) parameter, an assertion error occurs. 

Resolution


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

       Cumulative Update 3 for SQL Server 2016 SP2

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.