My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/How big is your procedure cache?
The new RSS feed is here
There have been continuing reports by most people I
speak to about theire procedure cache becoming huge. Especially on 64 bit
systems with lots of memory. Memory that you want for your data.
The issue is due to the storinging of compiled adhoc plans. They just aren't
getting aged out of the cache.
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/How big is your procedure cache?