Optimise your server and workstations to minimise performance issues in QuickBooks Desktop.
This is Part 1 of a series covering performance issues in QuickBooks Desktop and how to resolve them. If the steps outlined here do not resolve your issues, try the steps in the other
Enhance your computers
QuickBooks system requirements will support most QuickBooks users. If your computer system meets these specifications and still experience performance issues, increasing your available RAM may improve the condition. Remember that your goal is to increase the amount of RAM available to QuickBooks.
To know the amount of RAM needed for QuickBooks operations, multiply the size of your file in GB, by the number of users in the network. So, if your file size is 500 MB (0.5 GB) and you have 6 users, then you need 3 GB of RAM in your server. If you have only 2 GB and you are experiencing performance issues then 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.
A competing program is one that is running at the same time QuickBooks is running. Each competing program requires RAM and processor capacity. You can see the competing programs by opening the Task Manager and clicking the Processes Tab.
- 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
If you decide to upgrade your server and/or workstations, please consider the following:
- 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.
If you are running QuickBooks in a terminal server environment, you can estimate the amount of RAM on the server in two ways. The first is that you need 0.5 GB of addressable RAM for each user. If you have five users, you need 2.5 GB of RAM. The second way is:
- 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
Note: Intuit supports Terminal Services mode only for QuickBooks Enterprise.
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.
If you do not have a dedicated host or serer, use these criteria to decide on which workstation to save the file. Save your data file on the workstation that:
- Has the full QuickBooks program installed on it.
- Is used by the person doing the most work in QuickBooks, to minimise data transfer over the network.
- Has the most RAM.
- Has the fastest clock speed.
- Has the least non-QuickBooks activity.
Your Data Folder
When creating or moving files, QuickBooks uses these default locations:
Optimise your network interface card (NIC) settings
View and Edit your 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.