Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring


Application profiling tutorials

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