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

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:


About service packs for SQL Server
About service packs for SQL Server

References

Learn about the terminology that Microsoft uses to describe software updates.
Властивості

Ідентифікатор статті: 3172997 – останній перегляд: 16 лист. 2016 р. – виправлення: 1

Зворотний зв’язок