Read more about the article sys.dm_exec_cached_plans
Microsoft SQL Server


The dynamic management view sys.dm_exec_cached_plans returns information on query plans currently in memory. This information can be useful for a lot of reasons: checking total memory allowed for cached plans, which plans aren’t getting reused, searching for certain query plan operators (for instance, scans), which query plans are high memory consumers etc.


Continue Readingsys.dm_exec_cached_plans