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 table fragmentation

 

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

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

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Diagnosing table 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.

 Task
  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. In Sybase Central, 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 Profiling Options page, click Overall database performance based on the database schema.

    2. On the Analysis File page, in the Save the analysis to the following file field, type C:\AppProfilingTutorial\analysis. If you are prompted to replace the file because it already exists, click Yes.

    3. Click Finish.

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

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

  6. Close Sybase Central.

Results

You have used application profiling to identify and fix table fragmentation.

 See also