New parameters for sp_monitor enable and sp_monitor disable, which allow these procedures to take a monitoring entity type as an argument. This allows only those configuration options required to access data for that entity to be turned on or off. If no argument is provided, or all is provided, the default behavior is to turn all the required configuration options ON or OFF.
sp_monitor enable [, "all" | '<type> [monitoring]' ] sp_monitor disable [, "all" | '<type> [monitoring]' ]
type – connection, statement, event, procedure, deadlock, or procstack. To enable or disable monitoring of all the possible entities supported, use all. Table 1 has information about the new monitoring types. See the table documenting all the monitoring types in the Reference Manual: Stored Procedures.
Monitoring type |
Tables accessed |
Configuration option |
Configuration option type |
|---|---|---|---|
deadlock |
monDeadlock |
deadlock pipe max messages |
Value |
deadlock pipe active |
Boolean |
||
procstack |
monProcessProcedures |
None |
N/A |
monitoring – optional parameter that follows the name of each monitoring type.
sp_monitor enable, connection sp_monitor enable, 'statement monitoring' ... sp_monitor disable, 'connection monitoring' sp_monitor disable, 'all monitoring'
