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.
This issue is fixed in the following cumulative updates for SQL Server:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Learn about the terminology Microsoft uses to describe software updates.