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 » Performance monitoring and diagnostic tools » Application profiling


Using the Application Profiling Wizard

You can use the Application Profiling Wizard in Sybase Central to perform a diagnostic tracing session for profiling applications. The wizard gathers data on how your applications are interacting with the database and provides you access to the data and with indexing recommendations, if relevant.


DBA or PROFILE authority.

Context and remarks


The Application Profiling Wizard cannot be used to create a tracing session for a database running on Windows Mobile. You must use the Database Tracing Wizard.

When you use the Application Profiling Wizard in Sybase Central, the wizard automatically creates a tracing database with the same name you specify in the wizard for the analysis file.

For more information about the indexing recommendations returned from the Application Profiling Wizard, see Index Consultant recommendations.

 Use the Application Profiling Wizard
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Click Mode » Application Profiling.

    If the Application Profiling Wizard does not appear, click Application Profiling » Open Application Profiling Wizard.

  3. Follow the Application Profiling Wizard instructions. Do not click Finish as this ends profiling, and closes the wizard.

    The wizard:

    • creates a local database to hold diagnostic tracing information

    • starts the network server

    • starts a tracing session

    • prompts you to run the application you would like to profile

  4. Return to the Application Profiling Wizard and click Finish.


The wizard returns its results and allows you to review the data it gathered during the tracing session.



 See also