Update to add a memory grant warning to the Showplan XML in SQL Server 2014 or 2016

Gilt für: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise


This update improves support for troubleshooting memory grant-related query execution issues by adding a new Showplan XML warning in SQL Server 2014 Service Pack 2 (SP2) or 2016.
When SQL Server detects a scenario in which memory grant usage is inefficient, the MemoryGrantWarning element is added to actual Showplan XML. This element contains information about initial request, granted memory, and maximum used grant. The most common scenario for this warning is when a query is using only a fraction of allocated memory grant. The other scenarios are rare, and relevant behavior of SQL Server may change in future versions.


This update is included in the following service pack for SQL Server:


Learn about the terminology that Microsoft uses to describe software updates.