These system procedures are used for:
Changing and reporting on configuration parameters
Reporting on system usage
Reporting performance behavior
Monitoring Adaptive Server activity
The procedures in this category are:
sp_clearstats |
sp_monitor |
sp_configure |
sp_monitorconfig |
sp_countmetadata |
sp_reportstats |
sp_displaylevel |
sp_showplan |
sp_helpconfig |
sp_sysmon |