Symptoms
An access violation or assertion occurs when you use the Dynamic Management View (DMV) sys.dm_exec_query_statistics_xml. This problem was first fixed in Cumulative Update 26 for Microsoft SQL Server 2017 and Cumulative Update 12 for Microsoft SQL Server 2019. As a part of the fix, the runtime parameter value (ParameterRuntimeValue) is removed from the Showplan XML when the DMV sys.dm_exec_query_statistics_xml is invoked.
When you use the DMV sys.dm_exec_query_statistics_xml to troubleshoot long-running queries, you sometimes have to get the ParameterRuntimeValue value for a specific stored procedure or query before the query finishes. We added a new global trace flag (TF) 2446 in this hotfix. This enables the collection of the runtime parameter value at the cost of introducing extra overhead.
Warning: TF 2446 is not meant to be enabled continuously in a production environment, but only for time-limited troubleshooting purposes. Using this trace flag will introduce extra and possibly significant CPU and memory overhead because we will create a Showplan XML fragment by using the runtime parameter information, whether the DMV sys.dm_exec_query_statistics_xml is called or not.
Resolution
This problem is fixed in the following cumulative updates for SQL Server:
Each new cumulative update for SQL Server contains all the hotfixes and security fixes that were in the previous build. We recommend that you install the latest build for your version of SQL Server:
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.
