Let I run multiple databases on a single database ASA9-server (or SQL Anywhere 12, or 16 ... ) Can I find out how much space in the cache (in pages or in percent) occupy each database?
sa_eng_properties: 'CurrentCacheSize' * 1024/ 'PageSize' = 262144 pages 'CacheFree' = 256654 pages sa_db_properties: DB1 = ? pages DB2 = ? pages ...
The server does not track the number of pages used per database, so this information is not available. (I've added this to the list of enhancement requests for some future release).
answered 19 Dec '12, 10:31