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 application profiling tutorials use the test database app_profiling.db which you create, not the sample database (demo.db). Do not use the sample database to complete the tutorials.
Creating a test database for the application profiling tutorials
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.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |