Symptoms
When you run a query that contains sys.database_permissions in Microsoft SQL Server 2014, a memory leak occurs in the MEMOBJ_SOSNODE type object.
Note The memory leak depends on how frequently the query restarts. The only way to release memory is to restart your instance of SQL Server.
Resolution
Cumulative Update information
The issue was first fixed in the following cumulative update for SQL Server 2014.
Recommendation Install the latest cumulative update for SQL Server.
