Wednesday, August 15, 2007 8:26 PM 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!

Thursday, August 16, 2007 8:59 AM 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

Thursday, August 16, 2007 3:27 PM by Jason Haley