Lesson 2: Identifying table fragmentation

Use this procedure to identify table fragmentation and how to locate table fragmentation warnings. It is recommended that you periodically check for fragmentation warnings on your production database.

Note

The statements you executed in the previous procedure introduced table fragmentation. However, on some systems there might not be enough table fragmentation to result in the warnings and recommendations described in this procedure.

To identify table fragmentation
  1. In Sybase Central, choose Mode » Application Profiling.

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

  2. On the Profiling Options page, select Overall Database Performance Based On The Database Schema.

  3. On the Analysis File page, save the analysis file in the appropriate directory. For example, C:\AppProfilingTutorial.

  4. Click Finish.

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

  5. To view more detail, double-click Fragmented Tables. A Recommendation window appears containing a SQL statement you can run to resolve the table fragmentation.