Use the application profiling tutorials to learn how to use the Application Profiling Wizard and the Database Tracing Wizard to analyze common performance problems including deadlocks, slow statements, index fragmentation, table fragmentation, and slow procedures.
The tutorials use the test database app_profiling.db which you create, and not the sample database (demo.db). Do not use the sample database to complete the tutorials.
You must have PROFILE authority to perform application profiling. For the application profiling tutorials, connect as a user with DBA authority.
Tutorial: Diagnosing deadlocks
Tutorial: Diagnosing slow statements
Tutorial: Diagnosing index fragmentation
Tutorial: Diagnosing table fragmentation
Tutorial: Baselining with procedure profiling
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |