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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Application profiling tutorials » Tutorial: Diagnosing index fragmentation


Lesson 1: Identifying and fixing index fragmentation using the Application Profiling Wizard

Use the Application Profiling Wizard to identify and fix index fragmentation. You should periodically check for fragmentation on your production database.


This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Diagnosing index fragmentation.

This tutorial assumes that you have created the test database, app_profiling.db. See Tutorial: Creating a test database for the application profiling tutorials.

  1. Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.

  2. In Sybase Central, connect to app_profiling.db as follows:

    1. Click Connections » Connect With SQL Anywhere 16.

    2. In the Connect window, complete the following fields to connect to the test database, app_profiling.db.

      1. In the User ID field, type DBA.

      2. In the Password field, type sql.

      3. In the Action dropdown list, select Start and connect to a database on this computer.

      4. In the Database file field, type C:\AppProfilingTutorial\app_profiling.db.

      5. In the Start Line field, type dbeng16 -x tcpip.

    3. Click Connect.

  3. Click Mode » Application Profiling.

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

  4. Start the Application Profiling Wizard as follows:

    1. On the Welcome page, click Next.

    2. On the Profiling Options page, click Overall database performance based on the database schema, and then click Next.

    3. On the Analysis File page, in the Save the analysis to the following file field, type C:\AppProfilingTutorial\analysis.

    4. Click Finish.

    A list of recommendations appears in the Application Profiling Details pane.

  5. If you see Fragmented Indexes, double-click it. A Recommendation window appears containing a SQL statement that you can run to resolve the index fragmentation.

  6. Close Sybase Central.


You have used the Application Profiling Wizard to identify and fix index fragmentation.

 See also