Looking into the contents of Plan Cache in SQL Server
In this post I will be demonstrating with hands-on examples how to look into the contents of Plan Cache. I will be explaining what the Plan Cache (Procedure Cache) is, the process of query optimization and the generation of execution plans in detail. Then I will use some DMVs to create a custom view that will return the contents of the plan cache. (
read more)