[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Quickbooks slow

Posted on 2013-02-01
8
Medium Priority
?
419 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 98

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 98

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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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 98

Accepted Solution

by:
John Hurst earned 1000 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 98

Expert Comment

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

... Thinkpads_User
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Many of us need to configure DHCP server(s) in their environment. We can do that simply via DHCP console on server or using MMC snap-in on each computer with Administrative Tools installed in a network. But what if we have to configure many DHCP ser…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

649 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