Article: SQL Server memory configurations for procedure cache and buffer cache

I’ve just published another tip over on  This one is titled SQL Server memory configurations for procedure cache and buffer cache.

To determine how much memory your SQL Server database uses for buffer cache and procedure cache, factor in the SQL version you’re using, whether it’s x86, x64 or Itanium and the amount of memory allocated to the SQL Server instance. I talk about how the system configures memory and how it allocates the amount of buffer and procedure cache that’s available.Denny


2 Responses

  1. In the article you state “Buffer cache cannot reside within the Address Windowing Extension (AWE)-controlled memory space”. I think you have that backwards. It is procedure cache that cannot reside in AWE. Buffer cache can.

  2. You are correct, I did manage to get those backwards. I’ll have the article corrected.

    Thanks for pointing that out.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trust DCAC with your data

Your data systems may be treading water today, but are they prepared for the next phase of your business growth?