Dear friends,

Last few days performance is very slow. We checked all the networking issue , LAN card , lease line and router. We are not able to trace the source of problem.
Some times it takes 7-8 minutes to login in , but same time if I try to login in same server through telnet , I am getting very quickly. Any execution from command prompt is fast. Most funny things is when we stuck in any session or in login at that time we checked the CPU uses are 15%-25% means 75%- 80% idle. We are not using any third party software in our server. We are not using the baandb for other external software. Our OS is UNIX and database is INFORMIX.

Any body faced such problem?

Had this situation some weeks ago.

Reason was defect switches (on the gateway).

After hardware exchange everythings works fine.

Sympton:

Sometimes fast, sometimes 30.000 ms response time without specific symptons (with or without networktraffic).

Regards,

Kozure

Jim van der Meij (where is the dude?) wrote an excellent document on troubleshooting Baan performance that was handed out during the 2003(?) BWU conference.

Unfortunately I lost my copy (along with the rest of my Baan library) so if anybody has it on file, send one my way too ;)

In this case I am surprised that the BW doesn't time out in 7 minutes. Remember that the client-server connection is initiated from the VM (bshell) on the server side. I would say that the login goes just fine but a subsequent step in the process causes your issue.

My personal rule of thumb: 99% of Baan performance problems occur in the database.

Have the informix statistics been updated recenty ?

Regards
Neal

Francesco,

The dude [Jim Vandermey] is here (http://www.ostusa.com/about/ost_team.asp)... ;)

I have Jim's 'Performance Tuning' document with title "Why is Baan Slow? ...when everything else is faster". It's a 14mb presentation though, so not the easiest thing to send by e-mail...

Regards,
Eli Nager

Where is possible download this presentation ?

In case , i have a area for upload file.

Thanks

Max

:)

Hi Eli Nager,

I am needing this document too.

Jeffers

Hi dear it could be problem of BW client what you are using try with the latest version of that . Just check it out what is the performance of your informix db server ( if its seprate ) . One thing you can do remove all the files from $BSE/tmp as well as increase the size of your /swap . if still you face a problem then tell me again we have the same scenario in my company. donot concetrate on the network some times it doesnt matter if you feel that its quite up to the mark. After deleting all file from /$BSE/tmp make one shutdown too. altogther upload the new patches if u use solaris unix or other.

Thanks,
Shiv sharma

i want the file too

Hi,

Thanks for giving answer and devote your time. I have done reorganize & Reconfigure entire table . It was pending last one year. After running above session problem was solved. Our data size is 83 GB.


Regards