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

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance

 

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.

Caution

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