on 2015 Jan 09 8:36 AM
Further insight into the SQL Anywhere 16.0.0.2052 CacheRead* and DiskRead* database properties is requested; in particular:
Why is the database property CacheRead SO VERY MUCH larger than the sum of CacheReadIndInt, CacheReadIndLeaf, CacheReadTable and CacheReadWorkTable?
SELECT CAST ( DB_PROPERTY ( 'CacheRead' ) AS INTEGER ) AS CacheRead, CacheReadIndInt + CacheReadIndLeaf + CacheReadTable + CacheReadWorkTable AS CacheReadPlua, CAST ( DB_PROPERTY ( 'CacheReadIndInt' ) AS INTEGER ) AS CacheReadIndInt, CAST ( DB_PROPERTY ( 'CacheReadIndLeaf' ) AS INTEGER ) AS CacheReadIndLeaf, CAST ( DB_PROPERTY ( 'CacheReadTable' ) AS INTEGER ) AS CacheReadTable, CAST ( DB_PROPERTY ( 'CacheReadWorkTable' ) AS INTEGER ) AS CacheReadWorkTable; CacheRead CacheReadPlua CacheReadIndInt CacheReadIndLeaf CacheReadTable CacheReadWorkTable ----------- ------------- --------------- ---------------- -------------- ------------------ 27863526 11558306 3030368 3116314 5406258 5366
Why is DiskRead database property is more-or-less-the-same as "DiskReadSome" (sum of DiskReadIndInt, DiskReadIndLeaf, DiskReadTable and DiskReadWorkTable) but does not appear to include DiskReadHintPages (included in "DiskReadAll")?
SELECT CAST ( DB_PROPERTY ( 'DiskRead' ) AS INTEGER ) AS DiskRead, DiskReadIndInt + DiskReadIndLeaf + DiskReadTable + DiskReadWorkTable AS DiskReadSome, DiskReadIndInt + DiskReadIndLeaf + DiskReadTable + DiskReadWorkTable + DiskReadHintPages AS DiskReadAll, CAST ( DB_PROPERTY ( 'DiskReadIndInt' ) AS INTEGER ) AS DiskReadIndInt, CAST ( DB_PROPERTY ( 'DiskReadIndLeaf' ) AS INTEGER ) AS DiskReadIndLeaf, CAST ( DB_PROPERTY ( 'DiskReadTable' ) AS INTEGER ) AS DiskReadTable, CAST ( DB_PROPERTY ( 'DiskReadWorkTable' ) AS INTEGER ) AS DiskReadWorkTable, CAST ( DB_PROPERTY ( 'DiskReadHintPages' ) AS INTEGER ) AS DiskReadHintPages; DiskRead DiskReadSome DiskReadAll DiskReadIndInt DiskReadIndLeaf DiskReadTable DiskReadWorkTable DiskReadHintPages ----------- ------------ ----------- -------------- --------------- ------------- ----------------- ----------------- 662 672 1197 23 262 387 0 525
User | Count |
---|---|
67 | |
11 | |
10 | |
10 | |
9 | |
8 | |
6 | |
6 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.