sp_sysmon for Adaptive Server 12.5.1 has been enhanced. A new cache wizard parameter aids in the monitoring and configuring of data caches for enhanced performance. The cache wizard allows you to identify:
“Hot” objects (objects that are often accessed). The output is ranked by the number of logical reads in a named cache or default data cache.
The usage of the cache and buffer pools.
The percentage of hits at a cache, buffer pool, and object level.
The effectiveness of large I/O.
The effectiveness of Asynchronous Prefetch (APF).
The cache occupancy by the various objects.
The cache wizard section appears in the sp_sysmon output only when you include the cache wizard parameter. You can include two parameters with cache wizard, topN and filter. topN ranks the objects while printing the report and filter prints cache names containing this pattern.
For more information about the cache wizard, see Performance and Tuning: Monitoring and Analyzing.
