[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Performance Issues with QuickBooks 2012 Pro

Posted on 2012-12-26
5
Medium Priority
?
895 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
[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
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

650 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