Solved

Performance Issues with QuickBooks 2012 Pro

Posted on 2012-12-26
5
881 Views
Last Modified: 2016-11-23
I have a user that's running QuickBooks 2012 Pro on her Windows 7 machine. She is running into a whole lot of performance issues. It takes upwards of 15 minutes to backup QuickBooks or to create an accountants copy. When performing regular tasks in the program, it often grays out and says "Not Responding" until it finally finishes. It only began taking this long is the past 2 months.

The company file is stored on a shared directory on their server. Only one user accesses the file at a time, so the QuickBooks server has not been setup. The file itself is less than 40 MB, so I know it isn't an issue with company file size. Below are some details...

User's Workstation
Dell Optiplex 7010
Windows 7 Professional 32-bit SP 1
4 GB Memory (PC 12800, 1600 MHz)
Intel(R) Core(TM) i5-3470 CPU @ 3.20GHz (Quad-Core)
QuickBooks 2012 Pro, all recent updates

Server
Dell PowerEdge 2900
Windows Server 2003 R2 SP 2
4 GB RAM
Intel(R) Xeon(R) E5405 CPU  @ 2.00GHz (Quad-Core w/ HyperThreading Technology)
RAID5 (Where company file is stored) w/ 15,000 RPM SAS drives

Network
Wired Domain Network
Gigabit switches (new) and NIC's
Company file accessed via local network, so it shouldn't hit their firewall.

Things I have tried...

- Update QuickBooks.
- System tuneup on both the workstation and server. This includes disk cleanup, optimized defrag, registry cleanup, correction of any event log errors.
- Added exceptions on all antivirus/antimalware software on both the workstation and server. Exception includes both the QuickBooks application folder as well as the entire shared QuickBooks directory.
- Verified company file data.
- Verified that Google Desktop was not installed.
- Ran reboot.bat in the workstations QuickBooks installation folder.
- Reinstall QuickBooks on the workstation.

I'm having allot of trouble trying to figure out why I'm having performance issues. I will say that it seems like things got worse once she moved from Windows XP from her old PC to her new Windows 7 machine, though I can't see how this is related as the hardware specs greatly improved with this switch. Any ideas?
0
Comment
Question by:SWTHOMAS
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:hpdvs2
ID: 38721224
1, Try copying the file directly to her machine.  Not to use there, but just to make sure that it copies over without issue.

2, Is that the only application running slowly on her machine?

3, I presume based on your message, that there are other users, that have no issue like this.  And if so, you should rule out the server.

4, Is this a constant issue?  I.e. every time she uses it, the same results happen, or is it more like a 7AM thing, or 3:30 pm thing?  Perhaps there is a backup running on the server at the same time she is using it.  Where I work, we have a file space that everyone starts syncing up to around 8AM, and then it goes slow for everyone.  but around 9:30 and after, syncing is fast.

5, Check for other special utilities on her machine.  Perhaps she has an over zealous backup program, that runs on any change to a file, and pays attention to that file over the network?  (not likely)

6, Check her personal configurations in the software.  Perhaps she has options set up that do more work, or referential checks.  Might want to find where it stores the configuration settings, and do a windiff against hers and another person's file that runs better, and see if there are any red flags.

Finally, I recommend this: http://www.betterbottomline.com/docs/Danger%20Danger%20-%20Your%20QuickBooks%20File%20May%20Implode.pdf

as a general guide, though I'm not sure how directly effective it will be in helping you.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 38722960
We ran into the same problem with a network environment that is practiacly identical.  I wnt through the excersies you did to clean evrything up but it didn't help.

I tracked it down to packet inspection process that is part of Symantec Endpoint protection. We turned that process off and QB's ran much better.
0
 
LVL 25

Expert Comment

by:Tony Giangreco
ID: 38734488
Have you made any progress?
0
 
LVL 1

Accepted Solution

by:
SWTHOMAS earned 0 total points
ID: 38793805
I apologize for my delay in response. This particular user had not been using Quickbooks recently so I could not determine if any of the fixes worked.

I heard back from her and she reports that the performance issue is gone.

To correct the issue, I installed the Quickbooks Server software provided on the same installation media as the application itself. Once I did this and pointed it to the Company File, her issues seemed to go away.

What interesting is that they are using a single license, and simply take turns accessing the company file on a mapped server share.
0
 
LVL 1

Author Closing Comment

by:SWTHOMAS
ID: 38809136
This solution can be easily performed in any scenario where the company file is located on a shared directory on a server.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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…
I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

762 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now