Table of Contents

How to Fix the Cache Quantity for QuickBooks Desktop Enterprise?

QuickBooks is accounting & bookkeeping software which can be of a great help for your company. This is an accounting planning software easily that facilitates a business owner in operating his or her business smoothly. Nowadays, in this article we are going to inform you about how to fix the correct cache amount for QuickBooks Enterprise Solutions. After we have installed QuickBooks Enterprise then we can observe default values if memory cache that is utilized by the database manager. At times, these values get changed which causes slow performance of the desktop.

Trouble mostly occurs when the server gets rebooted or when the window gets updated. QuickBooks Enterprise 2019 has been released with enhanced and new features.

You always have two choices when it comes to updates

  • Automatic updates
  • Manual Updates

Reasons why correct cache amount has to be fixed for QuickBooks enterprise

  • Whenever we update a window to the newer version
  • While we reboot the server
  • When QuickBooks desktop is updated to the newer version

Now we are going to look ahead for troubleshooting correct cache amount for QuickBooks Enterprise but we would really like to encourage you to update your QuickBooks Enterprise because we have mentioned above.

Steps to Fix the cache amount for QuickBooks Enterprise

There are two steps commonly used to resolve the issue of proper cache amount for QuickBooks Enterprise.

Solution 1: Configure the amount of memory cache to use via the QBW.ini file

  • If the entire software is placed on web hosting computer then we adopt this software
  • Access the computer server that hosts the company files
  • Open the QBW.ini file within Intuit
  • Open QBW.ini file and then insert a DBSERVEROPTIONS section using the selected values

InitialCache= 256 (‘None’)

MaxCache= 512 (‘Unlimited’)

  • Save the file.
  • Press Enter to “take effect” for the .ini file setting
  • Shut down your host from the file menu and then restart

If you have “Server only install” then follow the below steps-

  • From The CMD, type: net stop QuickBooksDBXX
  • From the CMD, type: net stop QBCFMonitorService & then run QBCFMonitorService

Solution 2: Modify cache settings manually for Server-Only Install

We strongly advise that you must put yourself in touch with experts in IT immediately because modifying Windows Registry is not a job of ease.

  • Start command prompt set up to support multi-user access for the QuickBooks Desktop file. Paste and copy this in the text box: HKLM\\SYSTEM\\CurrentControlSet\\Services\\QuickBooksDBxx\\Parameters.
  • After -ch and -c check the numbers. Enterprise solutions fine with configuration -ch 512M and -c 256M. If your current configurations are not changing then modify it as below.
  • If error can be found then check that you have provided correctly.

Step 1: Modify the configuration in the registry:

  • Save all your work, files and log out in QuickBooks Desktop users.
  • Open the command prompt and then enter net ‘stop QuickBooks DBXX’ and press enter, as you need to stop QuickBooks Desktop Database service.
  • Now it is time to Edit the Windows registry, change location: HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\QuickBooksDBxx\\Parameters. The existing value must be like -n QB_SERVER_NAME -qs -gd ALL -gk all -gp 4096 – gu all -ch 256M -c 128M…

Step 2: Intuit recommends to following changes:

  • Replace -ch 512M with -ch 128M. Delete -ch 256M and -ch 512M for unlimited. The value should be like “-n QB_SERVER_NAME -qs -gd ALL -gk all -gp 4096 -gu all”.

Note: This is not entirely unlimited but the reality is that the “Database managed” and can utilize more memory when required.

  • Replace -c 128M with -c 256M.
  • Replace -ch 256M with -ch 512M.
  • If you see that the settings are already set at the suggested level then don’t adjust them. These files do not address the cause of your performance issues.
  • Save your changes.
  • Type “net start QuickBooksDBXX” on command prompt (xx should be used as your software version year).
  • Open QuickBooks and then open your company file.
  • Prior to choosing an option, ensure that QuickBooks Desktop Enterprise 14.0 or 15.0 is updated to the most recent version.