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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Application profiling tutorials


Tutorial: Diagnosing table fragmentation

Use the tutorials in this section to learn how to use the Application Profiling Wizard to determine if your database has unacceptable levels of table fragmentation.

Table data is stored on database pages. When Data Modification Language (DML) statements such as INSERT, UPDATE, and DELETE are executed against a table, rows might not be stored contiguously, or might be split between multiple pages. Even though CPU activity is high, table fragmentation can negatively impact the performance of queries that require a scan of the table.

Lesson 1: Setting up table fragmentation
Lesson 2: Identifying table fragmentation
Lesson 3: Checking for table fragmentation