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.
enable monitoring – set to 1. This option is dynamic.
per object statistics active – set to 1. This option is dynamic.
object lockwait timing – set to 1. This option is dynamic.
For more information about configuration parameters, see Chapter 5, “Setting Configuration Parameters,” in the System Administration Guide, Volume One.
