FIX: Memory grant that's required to run optimized nested loop join isn't reflected in Showplan XML in SQL Server

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

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.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.