Solved

Quickbooks slow

Posted on 2013-02-01
8
416 Views
Last Modified: 2016-11-23
I have a new customer who was complaining of slowness with Quickbooks.  It is the server version of QB2008 with 4 simultaneous users on a Dell sc440 with win server 2003.
I added memory to bump it from 1 gig to 3 hoping that would solve the problem and it did not.  The QB Database itself is large and goes back 4 years.

How can I speed this up?  Is there a way to archive the database so just the last 2 years are active without losing all the custom drop down lists, etc.  Or is there a way to provision more of the new memory to QB?

Any advice would be greatly
0
Comment
Question by:jbasiliere67
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 95

Expert Comment

by:John Hurst
ID: 38845901
Is there a way to archive the database See if your version has the ability to condense the Company database. Be very careful with Condense and be certain to have a backup before trying it. The goal is to reduce the database size.

If the Condense function is not there, then you need to look at 3rd party tools to condense it. I included one such link below here.

http://quickbooksusers.com/file-shrink.htm


Otherwise, you need to look at having QuickBooks on its own server to make a real gain.

Or is there a way to provision more of the new memory to QB?  No, not really.

QuickBooks is naturally slow, so you will have to let your customers know this as well.
0
 

Author Comment

by:jbasiliere67
ID: 38898675
Hi,

I do have QB on it's own server and as I've said recently bumped the memory on theserver to the max of 3 gig.  

When I try the compression utility or the archive as of certain date utility, it freezes.  I think the archive utility will work for me because the my customer reports that his newer clients with just a few transactions in the system open quickly and perform fast.  It is his clients with high volume of transactions in their record that are slow.  I would guess that if I can archive the data base so that only the last year of transactions are active, then even the large volume customers records will open more quickly.  

As you mentioned, when I try to do this I have to back up and verify data.  It is during this process that QB freezes.  Any ideas on this?

Thanks fro the help.

John
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 38899066
Copy (not move) the QuickBooks database to a local machine that has QuickBooks.

Open the QB database locally and then do a verify. See if the verify completes.  If it does, do a rebuild (again locally) and allow to rebuild.

If the verify does not work, try a Rebuild without first verifying. This can be done. Make certain you are working locally.

If you cannot verify and cannot rebuild, you will need to contact Intuit Support and use their repair service. They have the tools to fix databases.

Once sorted out (one way or the other from the above), you should be able to compress the database.

.... Thinkpads_User
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:jbasiliere67
ID: 38905334
OK.  Thanks.  I won't be able to try until this weekend.  Will post results and point then.

Thanks!
0
 

Expert Comment

by:rkedia99
ID: 39022148
You might want to go through the following post on increasing the cache used by QuickBooks database to improve performance.

http://forums.quickbooksusers.com/archive/index.php/t-39666.html

Regards

- Rajiv
0
 

Author Comment

by:jbasiliere67
ID: 39037430
Thanks.  I'll give check out the article and give it a try.  I was able to copy the file to a local computer but kept recieving "Data related errors" which did not allow the rebuild to complete.
0
 
LVL 95

Accepted Solution

by:
John Hurst earned 500 total points
ID: 39037451
but kept receiving "Data related errors" which did not allow the rebuild to complete.

If you cannot rebuild the file locally, you need to contact Intuit Support. They may need to service the file to remove errors. That, in turn, may account for the slowness. But in any event, the file should get repaired.

... Thinkpads_User
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 39107693
@jbasiliere67 - Thank you, and I was happy to help you here.

... Thinkpads_User
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question