Checking your DB File Fragments is a part of performance troubleshooting. Press F2 (or Ctrl + 1) in QuickBooks Desktop, to see your "DB File Fragments" number. An excessive number of DB File Fragments can degrade your performance.

Detailed information

What are DB File Fragments?

DB File Fragments are:
  1. Discrete blocks of your hard drive in which Windows is storing your data file.
  2. A normal part of the operation of any program running under a Windows OS.
  3. A function only of the hard drive on which your data file is stored.

DB File Fragments are not:

  1. Created by QuickBooks Desktop or by the data manager.
  2. Corrupted blocks of your company data file.
  3. Causes or indications of damage in your data file (e.g., balance sheet out of balance).
  4. Related to QuickBooks Desktop users or how they log in to the data file.

For more information, see http://windows.microsoft.com/en-US/windows-vista/What-is-disk-defragmentation

 

How do DB File Fragments affect QuickBooks Desktop operation?

Fragmentation is neither a cause of nor an indication of damage in your company data file.

 

Fragmentation is not a reason to reinstall QuickBooks Desktop or to reenter data.

Excessive fragmentation can decrease performance because QuickBooks Desktop (and other applications) must read multiple blocks on your hard drive to retrieve data from a single file. Some guidelines are:

  1. DB Fragments fewer than 100 usually do not affect QuickBooks' performance.
  2. If your DB Fragments are more than 100, you should defragment your server/host hard drive (see below).

Reduce DB file fragments

Caution: Do not use the procedures in this article if your server/host has a solid state drive (SSD). This type of drive should not be defragmented.

Check if your computer has a Solid State Drive (SSD)

Windows 10

  1. From your keyboard, press the Windows logo.
  2. Enter Optimize and click Defragment and Optimize Drives.
  3. The Optimize Drives window opens.
  4. The Media type column tells you if your computer is running SSD or HDD.
Windows 8.1/ 8/ 7/ Vista
  1. Go to Computer and right-click your Local Disk drive (C:).
  2. Click Tools and then click Optimize.
  3. The Optimize Drives window opens.
  4. The Media type column tells you if your computer is running SSD or HDD.
 

Other Articles To Try