Preparing to run the cache wizard

sp_sysmon retrieves the information for the Cache Wizard from monitoring tables and monitor counters.

See Performance and Tuning Series: Monitoring Tables for more information.

The Cache Wizard report requires the following configuration parameters to be enabled. If these configuration parameters are not enabled, sp_sysmon automatically enables them at the beginning of the interval and disables them at the end (all these options are dynamic):

For more information about configuration parameters, see Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide, Volume One.