Finding the problem is the hard part
Interesting blog on how finding performance problems takes 80% of the mean time to resolution.
Sybase ASE Performance and Tuning
This is why I like DB Optimizer so much. DB Optimizer let’s me find the root problem in seconds on a database.