You must configure the monitoring table infrastructure before you can use the enhancements to sp_monitor.
The following examples are typical commands, performed to monitor deadlock events from the monDeadLock table.
sp_configure "deadlock pipe max messages",200 sp_monitor enable, deadlock
The configuration option enable monitoring must
be ON for any kind of monitoring activity to take place.
