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?