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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Monitoring and improving performance » Application profiling


Application Profiling Wizard

The Application Profiling Wizard in Sybase Central provides you with a simple, automated method of performing a diagnostic tracing session for the purpose of profiling applications. The wizard gathers valuable data on how your applications are interacting with the database, and then it provides you access to the data it gathered, as well as indexing recommendations, if any. See Application Profiling 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 database files created for application profiling and diagnostic tracing, see Tracing session data.

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. See Creating a diagnostic tracing session.

To use the Application Profiling Wizard (Sybase Central)

  1. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

  2. From the Mode menu, choose Application Profiling.

  3. Follow the Application Profiling Wizard instructions.

    If the Application Profiling Wizard does not appear, choose Application Profiling » Open Application Profiling Wizard, and follow the instructions.

    The wizard creates a local database to hold diagnostic tracing information, starts the network server, starts a tracing session, and then prompts you to run the application you would like to profile. Do not click Finish; this ends profiling, and closes the wizard.

  4. Run the application you want to profile. Or, if you are profiling general database usage, allow some time for gathering data. When you have finished, return to the Application Profiling Wizard and click Finish. When the wizard finishes, it returns its findings and allows you to review the data it gathered during the tracing session.

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

For more information about the procedure profiling information gathered during the tracing session, see How to read procedure profiling results.


You can disable the Application Profiling Wizard from starting automatically when switching to Application Profiling mode. To do this, on the first page of the wizard select In The Future, Do Not Show This Wizard After Switching To Application Profiling Mode. You can also suppress the first page of the wizard by selecting In The Future, Do Not Show This Page. To change these options at any time, choose Tools » SQL Anywhere 11 » Preferences, select the Utilities tab, and then select the appropriate options.

See also