In my experience the CacheRead and CacheHits property values are always (effectively) the same, even when the cache has been flushed, and this has been true for all versions extending from 12 back to (at least) 8. Here's a test in V12... CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; CALL sa_flush_cache(); SELECT COUNT(*) FROM SYSCOLUMN CROSS JOIN SYSOBJECT; SELECT DB_PROPERTY ( 'CacheRead' ), DB_PROPERTY ( 'CacheHits' ); DB_PROPERTY('CacheRead'),DB_PROPERTY('CacheHits') '448796','448539' Clearly, either I'm as dumb as a sack of rocks, or something isn't doing it's job. Or both. According to the Help, CacheRead and CacheHits properties are important http://dcx.sybase.com/index.html#1200en/dbusage/perform-s-5421283.html
|