sp_sysmon displays performance information about Adaptive Server. Use sp_sysmon to display performance information about the secondary data cache. This information is displayed in the Data Cache Management section.
For example:
Cache Statistics Summary (All Caches)
-------------------------------------
per sec per xact count # of total
-------------------------------------------
...
Secondary Cache Search Summary
Total Cache Hits 152448.5 432.2 15286912 100.0 %
Total Cache Misses 26.6 28.0 1597 0.0 %
--------------------------- -------- ------- ---------
Total Cache Searches 152475.2 450.3 15288509
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
