Record as much of the following performance information as possible. Sybase monitors include ASE Monitor, 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.
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.
See thePerformance and Tuning Guide for information about using Sybase tools and stored procedures to monitor performance factors.
