Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

MS Dynamics GP 9 and SQL Server 2000 with SP 4, processing is very slow

MS Dynamics GP 9 and SQL Server 2000 with SP 4, processing is very slow

MS Dynamics GP 9 and SQL Server 2000 with SP 4, processing is very slow


I have MS Dynamics GP 9 with SP 4 and SQL Server 2000 SP 4, client are installed on individual user system and the customization done for screen as per user requirement, also we have home made application for Barcode (for produce qty punching(No Mfg module), receiving at Warehouse)also while sales Delivery batch created through barcode and then convert into dispatch and invoice.

the issue is we are getting several complains for system slow and several time GP is getting hang, some time errors Network time out.

I have checked the details in server and event viewer there is no issue found in Event and Netowrk is also good,

Log analysis show me the higher latency in cache memory, and several sleep connection(200) on SQL.

Hardware : Intel Xeon 2.6 Ghz, 8 processor with 24 GB RAM, Windows Server 2003 enterprise edition 32 bit

Barcode application developed in Vb.net and customization in GP in VBA,

please help me to resolve the same

Salman Jafri

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close