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

Published On: 2008-06-10By:

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

Contact the Author | Contact DCAC

2 responses to “Article: SQL Server memory configurations for procedure cache and buffer cache”

  1. Avournas says:

    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. Mrdenny says:

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

    Thanks for pointing that out.


Globally Recognized Expertise

As Microsoft MVP’s and Partners as well as VMware experts, we are summoned by companies all over the world to fine-tune and problem-solve the most difficult architecture, infrastructure and network challenges.

And sometimes we’re asked to share what we did, at events like Microsoft’s PASS Summit 2015.

Awards & Certifications

Microsoft Partner   Denny Cherry & Associates Consulting LLC BBB Business Review    Microsoft MVP    Microsoft Certified Master VMWare vExpert
INC 5000 Award for 2020    American Business Awards People's Choice    American Business Awards Gold Award    American Business Awards Silver Award    FT Americas’ Fastest Growing Companies 2020   
Best Full-Service Cloud Technology Consulting Company       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers
Share via
Copy link