This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Buffer Cache Size & Buffer Pool Extension

Hi,

Our production SQL Servers here all haved 100Gb of buffer pool extension. Each machine has 64Gb RAM. DPA is showing the Buffer Cache Size at just under 60Gb. Could someone please answer the following for me:

- I presume this doesn't include what's in the BPE? Is this correct?

- Does this represent just data pages in cache or items such as the plan cache? If not please could you let me what's included?