Record as much of the following performance information as possible. Sybase provides monitoring capabilities in the form of Monitor Server, monitoring tables, Historical Monitor, and sp_sysmon.
CPU utilization: Use operating system and Sybase monitors to measure the average and maximum CPU utilization (aggregate and per CPU on SMP servers) per “time window” (for example, online or batch) per server.
Disk I/O:
Use operating system monitors to measure I/Os per second per disk and controller, and I/O queue lengths per “time window” per server.
Use Sybase monitors to measure total I/Os, reads, and writes per second per Sybase device per “time window” per server.
Concurrency:
Use Sybase monitors to determine the average lock contention.
Network I/O:
Use Sybase monitors to record average execution rates for critical stored procedures.
Use operating system monitors to measure the packets per second per network interface card per “time window” per server.
Use Sybase monitors to measure the TDS packets (“sent from” and “received by”) per “time window” per server.
Use the monitoring tables to gather statistical and analytical information about the state of the server.
Memory:
Use operating system monitors to determine the paging/swapping rates per second per “time window” per server.
Use Sybase monitors to determine the data and procedure cache hit rates per “time window” per server.
Once you have completed the upgrade to Adaptive Server release 15.0 , use query metrics utility to compare prior abstract plans with current abstract plans.
See the Performance and Tuning Guide: Monitoring and Analyzing for information about using Sybase tools and stored procedures to monitor performance factors.
