Operational Defect Database
BugZero found this defect 608 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2024688
KB5017788 - FIX: ParameterRuntimeValue is missing from the Showplan XML when you use the DMV sys.dm_exec_query_statistics_xml - Microsoft Support
Last update date:
2/16/2023
Affected products:
SQL Server 2017 on Windows
SQL Server 2017 on Linux
SQL Server 2019 on Windows
SQL Server 2019 on Linux
Affected releases:
build lower than 15.0.4298.1
Fixed releases:
15.0.4298.1
Description:
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: Cumulative Update 19 for SQL Server 2019 Cumulative Update 31 for SQL Server 2017 About 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: Latest cumulative update for SQL Server 2019 Latest cumulative update for SQL Server 2017
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.
