Cache Wizard

The “Cache Wizard” section can help you monitor and configure caches for optimal performance.

sp_sysmon cache wizard requires that you enable the object lockwait timing configuration parameter.

Cache Wizard allows you to identify:

The “Cache Wizard” section appears in sp_sysmon output only when you specify the cache wizard in sp_sysmon syntax. You can include two parameters with Cache Wizard, topN and filter. sp_sysmon does not include other sections (“Kernel Utilization,” “Worker Process Management,” and so on) when you include cache wizard in the syntax.

sp_syntax includes a recommendation section at the end of its printout.