FIX: Memory leak when you query sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016

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

Symptoms


A memory leak occurs when you query the sys.dm_sql_referenced_entities view in SQL Server 2014 or 2016. Eventually, the query fails, and you receive the following error message:
 
Msg 701, Level 17, State 123, Procedure procedure_name, Line 5 [Batch Start Line 4]
There is insufficient system memory in resource pool 'default' to run this query.

Resolution


This issue is fixed in the following cumulative updates for SQL Server:
   

Status


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

References


Learn about the terminology Microsoft uses to describe software updates.