Summary
The optimized nested loop join operator uses memory grant during query execution. This information isn't available in the queryplan. This makes troubleshooting of problems related to query execution memory usage more difficult.
Resolution
Service pack information for SQL Server
The update is fixed in the following Service Packs for SQL Server.Service Pack 2 for SQL Server 2016
Service Pack 3 for SQL Server 2014
Service Pack 4 for SQL Server 2012
Note In SQL Server 2014 SP2, the MemoryFractions showplan XML attribute is updated for the optimized nested loop join operator to reflect the memory that's required to run it.
Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You don't have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.How to determine the version, edition and update level of SQL Server and its components
Status
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
