1) First check your hardware and network requirements against the following list. For a 32 bit operating it makes sense to go up to 4GB of memory. If you have a 64 bit operating system it can address more than 4GB or memory. If you have 2GB of memory or less you should go to a least 4GB of memory.
QuickBooks Enterprise Solutions hardware and operating system requirements (client and server)
- Client:
- 2.0 GHz processor, 2.4 GHz recommended
- 1 GB RAM for single user, 2 GB RAM recommended for multiple users
- Server:
- 2.0 GHz processor (1.2 GHz for Linux), 2.4 GHz recommended (2.0 GHz for Linux)
- 1 GB RAM, 2 GB RAM recommended – Server
- Disk space (client and server): 2.5 GB of disk space (additional space required for data files)
- 4x CD-ROM drive required for CD installations
- Minimum 1024 x 768 screen resolution or higher; 16-bit color or higher
- Windows:
- U.S. version of Windows only.
- Regional Settings are supported when set to English (United States) with keyboard setting to U.S. only
- Natively installed
- Disk space requirements for additional software: 250 MB for Microsoft .NET 3.5 Runtime, provided on the QuickBooks CD.
- Minimum network requirements:
- 100 Mbps network card
- 100 Mbps switch or router
- 40 Mbps network bandwidth
2) Do a manual backup of the company file.
3) Delete the “company file name”.tlg log file which is located next to the company file. The tlg log file will rebuild itself.
4) Optional – rebuild the QB data under File – Utilities – Rebuild Data. The rebuild will prompt you for another backup.
5) Optional – clean up company data (remove transactions) under File – Utilities – Clean up company data. This may be necessary if you have a huge company file and many years of historical transactions.
6) With QB Enterprise open press the F2 cmd key. Look for the number of DB File Fragments. If DB File Fragments are over 10 create a portable company file under File – Create Copy, rename the company file, then restore the portable company file under File – Open or Restore Company.
7) Evaluate. If you notice a performance improvement you probably don’t need to go any farther. Delete the tlg file on a weekly basis and continue to monitor.