Use sp_sysmon to gather information about Adaptive Server current utilization during peak and idle times (typically, a two to five-minute sample is sufficient, but knowledge of your particular environment is necessary to determine both the quantity and frequency of the samples taken). See “Monitoring Performance with sp_sysmon” in the Performance and Tuning Guide: Monitoring for information on using sp_sysmon.
You can also use monitoring tables to evaluate overall server performance. See “Monitoring Tables” in the Performance and Tuning Guide: Monitoring.
You can use third-party tools such as Database Expert to benchmark and document query performance in your current Adaptive Server configuration. For more information, see “Analyzing Performance Changes during Adaptive Server Migrations and Upgrades with Sybase Database Expert” at http://www.sybase.com/detail?id=1028449.Third party tools can also be used to obtain and analyze both query- and server- level performance data.
