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 » Index Consultant


Obtaining Index Consultant recommendations for a database

To obtain Index Consultant recommendations for an entire database, use the Application Profiling mode in Sybase Central.


DBA or PROFILE authority.

Context and remarks

The Index Consultant needs profiling data before it can make its recommendations. The following procedure is a quick way to gather data and obtain the recommendations using data gathered by the Application Profiling Wizard. However, if you already have application profiling data (for example, if you profiled your database already using the Database Tracing Wizard), you can also run the Index Consultant on the tracing database that you created.

 Obtain Index Consultant recommendations for a database
  1. Use the SQL Anywhere 12 plug-in to connect to the database.

  2. Click Mode » Application Profiling.

  3. Follow the Application Profiling Wizard instructions.

    If the Application Profiling Wizard does not appear, click Application Profiling » Open Application Profiling Wizard, and follow the wizard instructions until it completes.

  4. In Sybase Central, click Application Profiling » Run Index Consultant On Tracing Database.

  5. Follow the Index Consultant Wizard instructions.


The recommendations of the Index Consultant are displayed.