Help! Accpac is very slow running throught Network!

[herbertlee]

Hi, our company are currently running ACCPAC small
business edition 5.3a and pervasive sql 8.6 server.
Now the problem we encounter is while running ACCPAC
on the server, everything works fine. However, when
we try to access ACCPAC on our network, the system
tend to take much longer time to finish the same task.
For instance, if we do a transection history checking
on the server it only take 10-15sec max. But if we
running it through the network with the same data
base, it will take upto 2-3 mins or more. NOw we
already installed the SQL client on our network and
that seem to help abit but still not able to solve
this problem. Any Suggestion?

 

[fitedgar]

jayconverse has already responded to your (duplicate) post. It is impolite or ungrateful not to acknowledge his response.

EMC
Integrated Bar Code Systems

 

[ettienne]

What anti virus software are you using?

 

[herbertlee]

Sorry, but I did try his advise, again, it speed ting up
abit but no major improvement. I start to believe using
terminal server is the only solution.

 

[jayconverse]

Sounds to me like weak network hardware. Terminal Services is an option for VPNs, not LANs.

Jay Converse
IT Director
Systemlink, Inc.

 

[herbertlee]

Hi, we already upgrade to gigalan and still no goes. When
running accpac locally or throught termail destop, it takes
rought the same time to finish the same tasks. However, if
we try to running accpac on the client system and accessing
database via odbc from the server, it will take at least 10
times longer to perform the same task! We can't figure out
what is the bottlenect here. Any suggestion?

 

[jayconverse]

Well, I don't know what a "gigalan" is, but I do know that switches and NICs have to be tuned together. Just because you have a 1 Gbps NIC doesn't mean you'll get that much throughput through your switch. Many times, one 10 Mpbs NIC will mess up everything else. I would isolate the server and one workstation alone on the same switch, then work outwards.

Also, if your DNS isn't properly configured, you'll get latency on the ODBC calls. A HOSTS file can fix that.


Jay Converse
IT Director
Systemlink, Inc.

 

[rschmitt]

Do your workstations have the min hardware requirements?

 

[herbertlee]

I think so. I have 3.0G Xeon, raid5 HD and gigalan network and switch. So I am pretty sure the networking is not the
bottleneck here. What we would like to find out is how
to speed up and what to upgrade? PS, we do isolate just
one client system and one server and accpac still running
much slower throught the network. Thank you!

 

[32321111]

First check points.
- No Event Viewer errors
- Verify use of CPU and memory
- The server is optimizated to "Maximize data throughput for network applications"
- Network cable is a CAT 5e (better CAT 6)
- Verify if you NIC has dropped packets

Second check points.

- Client version is the same as server?
- Client sql is the same as well?
- go to

http://yizhar.mvps.org/

download and extract the NUTS tool. Use the "Testfile.exe"
This tool can you show the avarege throughput between your client and the server.

If all tests show you don't have problem, then

You should create a isolated workstation with a new installation of WINXP SP2 and only accpac, get you best computer with a 1GB Network card.(you can use a laptop).

First you connect to the same switch you have the server, and then test the NUTS again and also the accpac times.
then you use a normal network point and test again.

Let me know if this help you
Regards
Marcio

 

[rschmitt]

check if your connection is running gig all the way, if you can upgrade to a raid 10 for performance on the server, that always helps. make sure that your SQL server is running on drives of its own. if you feel that the application is running slow make sure accpac is installed on a seperate server than the data and that the server is sufficient. you can run a trace in SQL and capture queries that are taking longer than usual. this will give you some direction if SQL Server is slowing you down or if it is your network. remember that your workstations have to have sufficient hardware. if you have a large network with lots of activity, put you accounting dept on a subnet of its own this will help with network performance.