A fragmented database file can affect the performance of your database server. Reducing disk fragmentation becomes more important as the size of your database increases.
The database server determines the number of file fragments in each dbspace when you start a database on Windows. The database
server displays the following performance warning in the database server messages window when the number of fragments is greater
Database file "mydatabase.db" consists of nnn disk fragments.
You can also obtain the number of database file fragments using the DBFileFragments database property.
To eliminate file fragmentation problems, put the database on a disk partition by itself and then periodically run one of the available Windows disk defragmentation utilities.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|