Performance tuning with sp_configure and sp_sysmon

sp_sysmon monitors Adaptive Server performance and generates statistical information that describes the behavior of your Adaptive Server system. See the Performance and Tuning Series: Monitoring Adaptive Server with sp_sysmon.

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.