Displays performance information.


sp_sysmon {'begin_sample' | {{'end_sample' | 'interval'}[, section]}}
	[, applmon=
		{'appl_only' | 'appl_and_login' | 'no_appl' | 'noclear' | 'clear'} 
	[, filter={cache_wizard_filter_value | 'noclear' | 'clear'} 
	[, dumpcounters={'y' | 'n' | 'noclear' | 'clear' | NULL} 
	[, option={'noclear' | 'clear' | NULL}]]]]




There are additional considerations when using sp_sysmon:
  • sp_sysmon displays information about SAP ASE server performance. It sets internal counters to 0, then waits for the specified interval while activity on the server causes the counters to be incremented. When the interval ends, sp_sysmon prints information from the values in the counters. See the Performance and Tuning Guide for more information.

  • To print only a single section of the report, use the valid values for sp_sysmon applmon.

  • If you use sp_sysmon in batch mode, with begin_sample and end_sample, the time interval between executions must be at least one second. You can use waitfor delay "00:00:01" to lengthen the execution time of a batch.

  • During the sample interval, results are stored in signed integer values. Especially on systems with many CPUs and high activity, these counters can overflow. If you see negative results in your sp_sysmon output, reduce your sample time.

See also Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.


You must be a user with execute permission to run sp_sysmon. The permission can be granted to other users by the database owner of sybsystemprocs.


Values in event and extrainfo columns from the sysaudits table are:



Audit option


Command or access audited

Execution of a procedure

Information in extrainfo
  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect