http://blogs.msdn.com/sqlprogrammability/archive/2007/01/08/plan-cache-concepts-explained.aspxSince the release of SQL Server 2005 there have been several questions around how plan caching has been implemented in this release and how to diagnose (and distinguish) plan cache related performance problems. In a series of blog articles we will attempten-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlprogrammability/archive/2007/01/08/plan-cache-concepts-explained.aspx#1481503Wed, 17 Jan 2007 07:29:02 GMT91d46819-8472-40ad-a661-2c78acb4018c:1481503Euan Garden's BLOG<p>and how its managed, and how its different in RTM, SP1 and SP2? Start here , it took me 2 nights to read</p> http://blogs.msdn.com/sqlprogrammability/archive/2007/01/08/plan-cache-concepts-explained.aspx#1681699Thu, 15 Feb 2007 10:40:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:1681699Gaurav Bindlish<p>It would probably a good idea to update this entry with URL's of all the points. That way I won't need to do the work of taking this post, adding all URL's and putting on my team's blog :)</p> <p>Great work,</p> <p>Gaurav</p>