GP Speed problem - SOP

[jymm]

GP9 - SQL 2005

Seems that when certain users transfer a quote to an Order OR when they transfer a batch of filled orders to Invoices things are AMAZINGLY slow. With other users the transfers happen in a reasonable amount of time. For the 'bad' folks I am talking a batch of 10 orders (2 or three lines each) taking 5-7 MINUTES... but a comperable batch for another user takes less than 45 seconds.

Non SOP users are seeing no performance issues, so I am pretty sure it is machine specific.

Anyone else run into anything like this & have a fix?

 

[Dukester0122]

Try the following:

1) Machine Specific

a) Check if all SOP users are using SQL Native Client as ODBC drivers(since you're using SQL 2005)
b) Check Dynamics.set if path is correct

2) Recreate all SOP Stored Procedures

 

[VictoriaYudin]

If it's only certain machines, I would look at the resources available on those machines. Check out the Event Logs - stuff like DCOM errors and antivirus warnings every few seconds would slow everything down. Also look for DNS and AD errors. Check network cards - dies copying a large file accross the network from these machines take the same time as the ones not hacing the problem? (by large I mean 200MB or more) Is logging in as administrator on the same machine showing the same results? If not, it could also be the Windows user that is causing the issue.

Hope thst gives you some places to start troubleshooting.

Victoria
Flexible Solutions, Inc.

 

[andersonch]

We had a similar problem. It ended up being a problem with our network. We moved to a new switch with a fiber connection and the problems went away.

Hope that helps.

 

[jazgeek]

things that I've tried in the past that may or may not have worked. This problem is common to older versions and resolutions have been many and varied.

new NIC
destroy profile and recreate with new system DSN
DNS rebuild
server DNS entry deletion and recreation
switch replacement
server NIC replacement
static route in host file
re-installation of GP
hitting side of computer really hard



-----------
and they wonder why they call it Great Pains!

jaz

 

[VictoriaYudin]

Great list, Jaz!

Victoria
Flexible Solutions, Inc.

 

[jymm]

Thanks folks - I appreciate all of the efforts

I have never had to go the whole route of hardware replacement, but that is interesting to know.

Essentially in our instance the users have admin rights on their machines (not for long). They were doing some self medication of their machines at the same time I was trouble shooting and not telling me... nah - I was not mad at all... Near as I can tell our problem stopped when one of the following took place
1) removal of Google desk top search (wonderful program, but wow - thise was chewing resources on my box when I was duplicating their machines)
2) removal of AIM and another instant mess program. I imagine this was a fair amount of the network traffic we were seeing off of the switch
3) I removed a number of the GP triggers & SP that were put out there so that we could see the other modules in our test companies and GP wanted to install them on EVERYTHING. Manufacturing had the triggers that I could see were the worse.

so - again - thanks much for the response - all are happy now.

btw - when I was looking for which triggers came with Manufacturing and other things that were installed (and that we wanted removed) I ran into some VERY interesting files. On my server Program Files\Microsoft DYnamics\Gp\SQL\INSTALL there is a directory for each product that was installed. Under that directory (and a folder down) you will find some .cmp files which have the database objects (tables, indexes, triggers, views) that were relative for that product. WOW - that was HUGE for un-installing Manufacturing from our server.