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 Guide for more information.

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 lets you observe the results of configuration changes.

This chapter includes cross-references to the Performance and Tuning Guide for the sp_configure parameters that can affect Adaptive Server performance.