Lists the currently enabled entities and necessary configuration options enabled for monitoring.
sp_monitor list
1> sp_monitor list 2> goMonitoring is currently active for the following types: mon_type --------------------- connection monitoring event monitoring procedure monitoring
procstack monitoring statement monitoring(5 rows affected)Monitoring types that are enabled but require some additional configuration options to be turned ON: mon_type config_name run_value cfg_value type -------- -------------------------- --------- --------- -------deadlock deadlock pipe max messages 0 0 dynamic(1 row affected)Monitoring related configuration options found to be enabled via sp_monitor: mon_type config_name run_value enabled type ---------- -------------------- --------- ------------------- ------- deadlock enable monitoring 1 Sep 3 2007 5:25PM dynamic deadlock deadlock pipe active 1 Sep 3 2007 5:25PM dynamic(2 rows affected)Monitoring related configuration options found to be enabled via sp_configure:config_name run_value cfg_value type mon_type ---------------------------- --------- --------- ------- ----------------------------------- max SQL text monitored 2048 2048 static connection, statement wait event timing 1 1 dynamicconnection,deadlock,event,statement per object statistics active 1 1 dynamic connection,procedure,statement SQL batch capture 1 1 dynamic connection,statement process wait events 1 1 dynamic event statement pipe active 1 1 dynamic procedure statement statistics active 1 1 dynamic procedure,statement statement pipe max messages 100000 100000 dynamic procedure,statement(8 rows affected) (return status = 0)
Use list to check whether the desired monitoring type is activated, or whether some configuration option is still missing.
Reports the configuration options that were set by sp_monitor, versus those options that have been set using configuration files or sp_configure.
