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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Application profiling

Application profiling Next Page

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.

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 on 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 CE. You must use the Database Tracing wizard. See Creating a tracing session.

To use the Application Profiling wizard in Sybase Central
  1. Connect to the database as the DBA.

  2. Choose Mode > Application Profiling.

    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.

  3. 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 on the indexing recommendations returned from the Application Profiling wizard, see Understanding Index Consultant recommendations.

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

Tip

You can disable the Application Profiling wizard from starting automatically when switching to Application Profiling mode. To do this, on the first screen 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, go to Tools > SQL Anywhere 10 > Preferences, select the Utilities tab, and select the appropriate options.