QuickBooks Enterprise Response Time

We have a new customer that is using QuickBooks Enterprise 14.0 on a Windows SBS2011 server.  The QB company file size is 428000kb.  The payroll clerk has asked for our assistance in improving the response time when she is processing a payroll of about 200 people.  The company file takes several minutes to open and is very slow when entering and processing payroll.  Her workstation is running Windows 7 Pro with 8GB memory  She has logged on at the server and processed the payroll with much faster response time but we know this is mainly because she is using the computer/server that is hosting the company file.  There are other users in the office that use the same company file for accounts payable or other accounting-related functions but do not use the payroll function.  They do not report the slowness issues like the payroll clerk.  The QB program is installed on each workstation and but the server hosts the company file.

We have checked the network connections, router, and switches and found nothing usual on their network.  Access times to shared network folders and printer appear to be adequate compared to other sites.  Their Internet response time is good considering they are in a rural community.  

We have several customers that use QuickBooks Pro and Premier editions but we do not have much experience with QuickBooks Enterprise.  Are there file size or record number limits or restrictions for this edition of QB?  Are there technical issues that could be causing the slowness across the network?

We would appreciate any suggestions for troubleshooting this issue.
Barnett ComputersIT Services CompanyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bryant SchaperCommented:
I have seen similar problem with quickbooks in the past, and yes it does have some limitations, suggest working with their support to DB fixes and cleanup.  Another option/test is from the server itself, how is performance.  We finally just setup users to RDP into the server instead of over the network.  Huge improvement.  If I remember right, I felt like the database was a bit like access, with a very "limited" amount of server side processing like you would leverage from SQL.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Barnett ComputersIT Services CompanyAuthor Commented:
Thanks for the reply.  I apologize for the delay in responding to your post.  We were able to get a copy of their company file and work with it on our computers and server.  The points you mentioned are in line with what we found.  The payroll clerk was the person that seemed to be most aware of the slowness.  We were told they only had about 350 employees but when we were able to examine the file, they had over 2500 employees over a two year span.  The 350 are only the active employees.  (They are a service center for seasonal farm workers.)  

We believe the number of total records in the company file is also a factor.  Besides the number of payroll records, they have over 7400 vendors in A.P.  We are also looking at the server configuration and load as a factor.

Your reply helped show we were going in the right direction for this customer.

Thanks again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.