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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and improving database performance » Improving database performance » Application profiling


Application Profiling Wizard

The Application Profiling Wizard in Sybase Central provides an automated method of performing a diagnostic tracing session for profiling applications. The wizard gathers data on how your applications are interacting with the database, provides you access to the data, and with 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 Create a diagnostic tracing session.

To disable the Application Profiling Wizard from starting automatically when switching to Application Profiling mode, 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 12 » Preferences, select the Utilities tab, and then select the appropriate options.

 To use the Application Profiling Wizard (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA or PROFILE authority.

  2. Choose Mode » Application Profiling.

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

  3. Follow the Application Profiling Wizard instructions. Do not click Finish; 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. 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.

 See also