Performance Tuning with sp_configure and sp_sysmon

sp_sysmon monitors SAP ASE performance and generates statistical information that describes the behavior of your SAP ASE system.

You can run sp_sysmon before and after using sp_configure to adjust configuration parameters. The output gives you a basis for performance tuning and allows you to observe the results of configuration changes.

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