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

Published On: 2008-06-10By:

I’ve just published another tip over on SearchSQLServer.com.  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.

Video

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       Insights Sccess Award    Technology Headlines Award    Golden Bridge Gold Award    CIO Review Top 20 Azure Solutions Providers    VMWare Partner
Microsoft Certified Master    Microsoft MVP
Share via