Contents Index Monitoring database statistics from Windows Performance Monitor File fragmentation

ASA SQL User's Guide
  Monitoring and Improving Performance

Fragmentation


As you make changes to your database, the database file, tables, and indexes can become fragmented. Fragmentation can decrease performance. Adaptive Server Anywhere provides information that you can use to assess the level of fragmentation in files, tables, and indexes.

This section describes how to detect fragmentation in files, tables, and indexes, and how to defragment them.


File fragmentation
Table fragmentation
Index fragmentation
Monitoring query performance

Contents Index Monitoring database statistics from Windows Performance Monitor File fragmentation