stehoban (4/25/2013)

---

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