Can I use the following query to find memory allocations for plans in the cache? How does this work? Are these memory allocations for only current connections?
top 20 *
join sys.dm_os_memory_clerks cl
join sys.dm_exec_cached_plans plans
This article is old but it speaks about what you are looking for.
Do not forget to read comments.
MCP, MCTS, MCITP
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?