Tables Huge cache size in memory?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  April 3, 2014 at 6:37 am

  #287196

  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