We present a method for troubleshooting performance problems in SQL Anywhere, with a focus on version 10. We describe the nature of performance problems and classify them into categories of cpu-bound, i/o-bound, and concurrency-bound problems. We describe the steps a dba should take to classify a performance problem, the tools provided in the product to examine the problem, and the analysis that must be done to resolve it.
Back to Top
