Great Plains running slow
Posted on 2013-01-14
We have a Citrix farm (XenApp 5.0) at Chicago Data Center of around 20 (Win 2003 std)servers. We have around 4 servers which are serving Great Plains10. Each two servers are load balanced for one GP applications (Lets say GP1 and GP2). We have two SQL servers (2005 Versions) running on two separate VM.
We had one more Citrix Farm (XenApp 4.0) at PPR Data center where there were same kind of setup but on Physical servers. We performed P2V and created all the VM in the new farm. GP installations are new and fresh.
Now users are complaining that they are getting Great Plains running very slow. They are actually complaining about two things-- i> when they are pressing tab button to move around from one field to another field its taking too much of time, ii> when they are fetching some image file inside Great Plains, its taking long time.
The images are stored in a file server which is in PPR. We checked network latency and it shows there is no issue at all from that side. We then performed compacting SQL database and that too didn't solve the issue.
We tried to launch the Great Plains from the server itself, its running slow there also.
There are two/three instances of time everyday when users are facing Great Plains running extremely slow for some 10 to 15 minutes before it goes back to its original speed which itself is very slow.
We checked that for all the time, each server is taking 10-18 sessions at a time. We even tried uninstalling Symantec AV, but it didn't solve the issue either. We checked all event logs but there nothing is found.
Application is used from Mumbai, India as well as US. The problem felt everywhere.
Need your help ........