Fragmentation

Normal database operations may cause the hard disk drive media and the stored Discover databases to become fragmented. Over time, disk fragmentation can significantly affect performance.

• As part of regular server maintenance, your DBA should perform disk fragmentation checks and defragment disks periodically.

The Discover database indexes can also become fragmented. Periodically, these should be defragmented to ensure optimal performance.

• Release 7.1 or earlier: You can run fragmentation checks and defragmentation tasks through Microsoft™ SQL Server Administration Console. For more information, consult the documentation that came with the product.
• Release 7.2: Through the Discover Database Manager, you can check the fragmentation status of your database indexes and run defragmentation tasks as needed.