×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

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!

*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

JD Edwards Server slow

JD Edwards Server slow

JD Edwards Server slow

(OP)
I just recently join new company, the use JDE as main business application. however i facing problem on JDE system with use complaint Enterprise server is slow, not sure is LAN problem or Server problem.

Problem:
oneworld Xe user complaint sometime slow server respone exp. went query the database for name it take 8-10 sec (ping to server respone time is 10ms) to display, normally is 1-2 Sec (ping to server respone time <1ms). but usually is happend in end of every month(closing Account)and duration not long around 10-15 minuts each time happending. 1 day can happend more than 10 times.  

JDE Server Spec
IBM WINTEL server Xeon 2.8 X 2 Windows 2003 server
4GB memory (usage is 70%)test using Solarwinds
72GB HD X5

Enterprise Server
oneworld Xe client for LAN user , around 40 Users
Citrix Server
Citrix Client for LAN user around 10 and for 2 branch (WAN) user aound 20 user.
MS-SQL Databases

LAN  Structure
6 L2 Standard Switches, all same, Dlink 1024R+ , 5 Switch uplink to 1 main switch, all is 100MB uplink only from each switch.
All oneworld Xe is use Switch 2 & 3.

My campany have 6 server, other server is Mail, file , Domain server, Deployment server, Proxy server.

I thinking is my LAN bandwith is not enought to support traffic, specially my 1st switch cannot handle all my server traffic, i plan upgrade 1st switch to 24Port GB switch and 2 & 3 switch with GB uplink, do you think this will help solve my problem? or is my server can not handle transection? any suggestion.

  
 







  

RE: JD Edwards Server slow

Depending onm the answer you receive,, there is also an EnbterpriseOne forum. On jdeslist.com,, you might try there, if you do not receive any answers..

RE: JD Edwards Server slow

You may also consider checking what is running in batch around the same time the end-user is doing their query.  Could be contention in reading the database.  Look at Submitted Jobs.

Also, consider the query that they are using.  Are they querying on fields that are part of an index on the table?

RE: JD Edwards Server slow

I agree with cglass.  I would also add that even if they are querying on an index, it may be helpful to rebuild the index.  I have encountered a few cases where the index was there but not being used.  Before rebuilding the query ran 3min, after 15 sec.

Just a thought.

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