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.