Cache wizard syntax

To obtain output from the cache wizard, use:

sp_sysmon begin_sample
sp_sysmon { end_sample | interval }
[, 'cache wizard'  [, top_N [, filter] ] ]

Parameters

For more information, see “Sample output”.

Example

This example runs the Cache wizard against the default data cache for a 5-minute interval, showing the top 15 objects in the cache:

sp_sysmon '00:05:00','cache wizard','15','default data cache'