Contents Index Fragmentation Table fragmentation

ASA SQL User's Guide
  Monitoring and Improving Performance
    Fragmentation

File fragmentation


Performance can suffer if your database file is excessively fragmented. This is disk fragmentation and it becomes more important as your database increases in size.

The database server determines the number of file fragments in each dbspace when you start a database on Windows NT/2000/XP. The server displays the following information in the server message window when the number of fragments is greater than one:

Database file "mydatabase.db" consists of nnn fragments

You can also obtain the number of database file fragments using the DBFileFragments database property.

For more information, see Database-level properties.

To eliminate file fragmentation problems

  1. Put the database on a disk partition by itself.

  2. Periodically run one of the available Windows disk defragmentation utilities.


Contents Index Fragmentation Table fragmentation