• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 900
  • Last Modified:

Performance Issues with QuickBooks 2012 Pro

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
SWTHOMAS
Asked:
SWTHOMAS
  • 2
  • 2
1 Solution
 
hpdvs2Commented:
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
 
Tony GiangrecoCommented:
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
 
Tony GiangrecoCommented:
Have you made any progress?
0
 
SWTHOMASAuthor Commented:
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
 
SWTHOMASAuthor Commented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now