This article is Part 2 in a set of 3 articles regarding performance issues in QuickBooks. If the steps in this article do not resolve your issues, try the steps in the other articles:
- Resolve QuickBooks Desktop performance issues: Identify types of Performance Problems
- Resolve QuickBooks Desktop performance issues: Manage your computers
- Resolve QuickBooks Desktop performance issues: Manage your data file
Enhance your computers
QuickBooks system requirements will support most QuickBooks users. If your network meets these specifications and you are having performance issues, increasing your available RAM may improve your issues. Remember that your goal is not necessarily to just increase the RAM in your network, but to increase the amount of RAM available to QuickBooks.
One recommendation regarding the amount of RAM in a server is to multiply the size of your file, in GB, by the number of your users. If your file size is 500 MB (0.5 GB) and you have 6 users, then this would suggest that you need 3 GB of RAM in your server. If you have only 2 GB and you are experiencing performance issues, consider upgrading your server to 3 GB of RAM.
- Increase a computer's Virtual Memory (VM) to 2 GB plus 2 GB for each major application running on the computer.
- Be sure that VM is running on an internal hard drive.
- If your server has multiple internal drives, store the data file on one drive and the VM on another drive.
- Shutdown programs and processes running on a computer. This enables the operating system to assign more RAM to QuickBooks.
- If you cannot shut down a competing program, move either QuickBooks or the competing program to another computer. A common example is the Exchange program that runs your e-mail system.
- In some systems, there are too many programs running on the Domain Server for QuickBooks to run efficiently. You should consider moving QuickBooks to another server.
- Add memory chips. If your server has four sockets, and 2 sockets have 1 GB DRAM chips, install two 1 GB DRAM chips in the empty sockets.
- Upgrade the existing memory chips, e.g., replace 1 GB DRAM chips with 2 GB DRAM chips.
- Increase workstation RAM.
- Be aware of your operating system's limits on the amount of RAM it supports.
Upgrade your operating system
- Make sure that the computer that will store the file is a true server ( not a service like Dropbox ).
- Fill all of the RAM slots with the highest capacity chips.
- A 64-bit computer & operating system.
- A fast clock speed of 2.2 GHz or more.
- A fast hard drive rotational speed, e.g., 7,500 or 10,000 rpm, or a solid state drive.
- A fast Network Interface. A 1 Gigabit per second (Gbps) card on your server can increase bandwidth.
- For 5 users, you need 2-3 GB addressable RAM
- For 10 users, you need 3-4 GB addressable RAM
- For 15 users, you need 4-6 GB addressable RAM
- For 20 users, you need 6-8 GB addressable RAM
Where to store your data file
- Where you store your company data file can have a noticeable effect on the performance of QuickBooks.
- You can set up a folder in your C: root directory to store your data file and ancillary files: C:\QBData\filename.qbw.
- Remember to move the entire data folder when you need to move the data file.
Use a networked computer
- Store your company data file on an internal hard drive in a computer on your network.
- Use an external hard drives or a flash drive only to back up your data file.
- We do not recommend using a Network Attached Storage (NAS) drive. QuickBooks for Windows is designed to store files on a computer with a Windows Operating System, or with a Windows compatible SAMBA share (Enterprise only).
- QuickBooks works with a server running a RAID (Redundant Array of Inexpensive Disks). Intuit does not recommend them because they have been linked with performance issues.
- Has the full QuickBooks program installed on it.
- Is used by the person doing the most work in QuickBooks, to minimize data transfer over the network.
- Has the most RAM.
- Has the fastest clock speed.
- Has the least non-QuickBooks activity.
Your Data Folder
Optimize your network interface card (NIC) settings
Network interface card (NIC) settings can slow the transfer rate if you have duplex mismatches. A duplex mismatch occurs when one NIC is set to a specific link speed and duplex and is connected to a NIC set to a different value. A mismatch can reduce your bandwidth to a few Megabits per second (Mb/s). To avoid this issue, reset all of your NIC's Link Speed and Duplex to an automatic setting.
- Click the Microsoft Windows Start button, select Control Panel. (In older Windows versions, you need to select Settings before selecting Control Panel.)
- Double-click System and select the Hardware tab.
- Click Device Manager.
- Click the + next to Network adapters to expand the list.
- Right-click the NIC and select Properties.
- Click the Advanced tab.
- Under Property, select the Link Speed & Duplex option (the option may be called something else similar).
- Click the Value drop-down arrow and select Auto (the option on your NIC could be named something else).
- Click OK and close the window.