15 August 2007 20:26 tonyrogerson

Configurable Procedure Cache for Katmai - vote on it!

Do you know what % of your SQL Server memory cache is being used by the procedure cache rather than data, you know - forcing you to get more of your data from disk rather than in cache. A client of mine on SQL 2000 recently had a proc cache of 800MBytes, this was standard edition and SQL was taking in total 1.7GBytes of memory - the procedure cache was nearly 50% of the memory allocated to SQL!

If like me you want a configurable option in sp_configure to control this then vote for it here:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=293188&wa=wsignin1.0

Tony

Filed under:

Comments

# re: Configurable Procedure Cache for Katmai - vote on it!

16 August 2007 08:59 by Colin Leversuch-Roberts

Whilst I can see in certain circumstances this being a good idea can you imagine the troubles that could be caused by allowing this?

On the other hand it could mean more unstable systems so more work for me!!

# Interesting Finds: August 16, 2007

16 August 2007 15:27 by Jason Haley