difference between moncachedObject.TotalSizeKB and monCachedObject.CachedKB
I was reading the definition of monCachedObject (sybase 15.5) and I actually don't understand the difference between
CachedKB | int | Number of kilobytes of the cache the object is occupying
TotalSizeKB |int | Partition size, in kilobytes.
Below is an example for one table on my database
Does it mean my table is using 3370308 Kb of the cache or 8429144 Kb of the cache
Jeff Tallman replied
TotalSizeKB is the size of that partition or table on disk for the given object id & index id. CachedKB is how much of it is in cache. So in the above case - assuming the IndexID=0 and we are talking about the table, then ~3GB of the table is in cache, and the table is ~8GB in size. Seems a bit high - either table is widely hit (e.g. a lot of reports, or it is a fairly volatile or highly referenced table) or indexing isn't very distinctive