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

Applies to: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise More

Summary


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.

Resolution


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


References


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