The sql server has 24Gb and the server's max memory is set to approx 19Gb.
From the 1st query listed above (to return the objects in the buffer) i get the following:
Object Name OnjectID IndexID BufferSize(MB) Buffer_Count
DIM_User 1290604532 1 121 15586
Fact_Cases 1914606755 0 56 7246
Im guessing that buffer size of 121, and 56 above is not big !!
However what does the Buffer_count column represent as this looks to be large !
Thanks