Use the application profiling feature to determine whether performance problems are caused by:
long application processing times
poor query plans
contention for shared hardware resources such as CPU or disk I/O
contention for database objects
suboptimal database design
When troubleshooting poor database performance, the first task is to determine whether the application or the database server is the primary cause. To determine how much processing time a client application is consuming, use the Details tab in the application profiling tool and filter the results by a single connection. If there are time differences between different requests from that connection, then the primary delay is within the application client.
If the database server is affecting performance, you will need to identify the specific cause.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|