Hi,
Table Name: Result
Actual Row count - 10798010
Cached_MB in memory - 4759 and Index-Id - 1 (it is primary key clustred Index)
This table accoupied most Cached in memory, Is it due to huge data in table? or more plan was generated and not yet resue again? I think every transaction create new plan and added into cache. am i correct?
Page Fullness - 90.26 %
Total fragementation - 0.42 %
Leaf Level Rows -12857400
Pages - 612056
I have tried, Re-organize and Rebuild that table but not cache size clear in memory.
Pls. sugestion.
Thanks
ananda