The Cache Wizard section can aid in the monitoring and configuring of data caches for optimal performance. 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.
Spinlock contention on the cache.
The usage of the cache and buffer pools.
The percentage of hits at a cache, buffer pool and object level. (THIS SENTENCE NEEDS TO BE MADE MORE CLEARER.
The effectiveness of large I/O.
The effectiveness of 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. See syntax details on “Cache Wizard syntax”.
A Cache Wizard recommendation section is printed at the end of the output on this report.Before you run sp_sysmon with the Cache Wizard section, you must first install the monitoring tables.
