SQL Server with Mr. Denny

Jun 10 2008   6:39PM GMT

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

Denny Cherry Denny Cherry Profile: Denny Cherry


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

2  Comments on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.
  • Avournas
    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.
    0 pointsBadges:
  • Denny Cherry
    You are correct, I did manage to get those backwards. I'll have the article corrected. Thanks for pointing that out.
    68,390 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: