Go Back > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 49

Baanboard at LinkedIn

Reference Content

Closed Thread
Thread Tools Display Modes
Old 20th June 2002, 11:37
heiko_s heiko_s is offline
Junior Member
Join Date: Feb 2002
Location: Germany
Posts: 4
heiko_s is on a distinguished road
Baan: IV, ERP - DB: DB2 - OS: NT, Unix
Question Performance Problems: what to check first?

hi all,

a customer complained about poor performance using the baan4c4-installation (oracle database).
the problem is, that the server is located in another country - so, sometimes it takes up to 10sec. to leave an input-field (because of "after-field-checks" or whatever)....
it is definitely a network-bandwith-problem. but they have no chance to change anything on their network in short term.

is there anything we can "tune" or change in the baan configuration to get a better overall-performance? increasing the memory for the database server?

thanks for your help,
Old 20th June 2002, 11:57
patvdv's Avatar
patvdv patvdv is offline
Board Master
Join Date: Aug 2001
Location: Belgium
Posts: 2,166
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux

If you are sure that the network bandwidth/latency is the problem then I am not very confident that increasing memory/CPU etc would solve any problems except when you already have issues in those areas as well. I think you should start with a general check on system/database and application level. For OS you can use proprietary performance tools (like glance on HP-UX) or more generic ones (sar,iostat etc). On database level you could generate simple statistics with bstat/estat or the Oracle Statspack if you are using Oracle. Also in case of Oracle: it would be worthwhile checking your listener configuration as you may be able to optimize some of the TCP settings.

Patrick Van der Veken - Admin & Founder - (c) 2001-2018
Sponsored Links
Old 24th June 2002, 12:08
bh_vfp's Avatar
bh_vfp bh_vfp is offline
Junior Member
Join Date: Feb 2002
Location: Vaassen, NL
Posts: 16
bh_vfp is on a distinguished road
Baan: Infor ERP Ln - DB: MSSQL 2005 - OS: Windows 2003
Baan has also a tool called Support Eye for a performance check.
solution 120511
Old 24th June 2002, 19:40
NPRao's Avatar
NPRao NPRao is offline
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,064
NPRao will become famous soon enough
Baan: Baan 4-5,5.2(Reger),LN-6.1,Infor LN-10.x - DB: Oracle,MS-SQL - OS: HPUX, Linux, Windows

1. You can use the top command in Unix which give you the process based output -

System: ABC Mon Jun 24 10:34:17 2002
Load averages: 1.09, 1.16, 1.29
492 processes: 465 sleeping, 27 running
Cpu states:
0 1.34 58.4% 0.0% 27.7% 13.9% 0.0% 0.0% 0.0% 0.0%
1 0.83 15.0% 0.0% 42.0% 43.0% 0.0% 0.0% 0.0% 0.0%
--- ---- ----- ----- ----- ----- ----- ----- ----- -----
avg 1.09 37.0% 0.0% 35.0% 28.0% 0.0% 0.0% 0.0% 0.0%

Memory: 937156K (526636K) real, 4335636K (1574592K) virtual, 51812K free Page#

1 ? 12955 oracle 154 20 36032K 3520K sleep 0:29 9.69 9.68 oracle
1 ? 12953 vxkum 154 20 283M 19540K sleep 0:18 6.91 6.90 oracle8
0 ? 12946 vxkum 154 20 31548K 25480K sleep 0:32 6.25 6.24 bshell
0 ? 20146 sdog 154 20 21308K 14332K sleep 0:03 1.68 1.68 bshell
1 tty0p0 35 root 152 20 0K 0K run 956:22 1.50 1.50 vxfsd
0 ? 0 root 127 20 0K 0K sleep 148:52 1.34 1.33 swapper
0 ? 9171 panrut 154 20 29500K 22372K sleep 0:10 1.33 1.33 bshell
1 ? 12113 ecs01 152 20 305M 10180K run 228:11 1.22 1.21 ecs.mcs
0 ? 9172 panrut 154 20 277M 14348K sleep 0:06 1.13 1.13 oracle8
2. You might consider changing the message mode - like using the page mode, so that the field validations are done after the user enters the data in the session/forms.

3. You can talk to the Network administrators wrt the bandwidth issues, memory issues with Unix administrators and Rollback/paging size etc settings with the Oracle-DBA's.
Attached Images
File Type: jpg userdata.jpg (58.5 KB, 307 views)
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Old 24th June 2002, 23:10
JamesV JamesV is offline
Senior Member
Join Date: Aug 2001
Location: Grand Rapids, MI, USA
Posts: 225
JamesV is on a distinguished road
Baan: Baan IV/5 - DB: Oracle 7/8/8i,Informix, SQL Server, UDB - OS: AIX, HP-UX, Tru64, Solaris, NT/2000
My thought is that you are experiencing extraordinary network performance issues. In my experience 90% of field to field delays are caused by network performance issues.

How many users are using the link? What is the bandwidth of the connection?

Implementation of network QOS in the infrastructure has provided some relief to sites running Baan that are experiencing contention between Internet, email, file transfer and Baan client applications. If the infrastructure has Cisco devices capable of this, you may be able to increase effective bandwidth without any capital outlay.

I have more to say, but have to leave for home.

Hope this helps,

Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
Old 25th June 2002, 17:10
Francesco's Avatar
Francesco Francesco is offline
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
My two cents


Ironically it was IBM who solved my performance problems after quite a few consultants had burned themselves on it.

What I learned during a disastrous year of frequent user complaints, is to never make any assumptions. Unless you can prove it is the network, keep your options open.

Start with some simple pinging and tracing to produce some numbers that might indicate that you are on the right track.

With Oracle as a back-end, it is quite possible that you have serious problems there. However, before throwing more hardware at it, make sure that the box and the application are properly tuned.
The Baan sizing guide is helpful in determining if your current hardware configuration is up to the task.
It will also give ou recommended settings for your system that are best followed to the letter (no matter what the non-Baan people say. lol)


Admiral Business Solutions | My World | Baan Board | IT Happens!

"If everyone is thinking alike, then somebody isn't thinking" -- George Patton
"It's easy to cry 'bug' when the truth is that you've got a complex system and sometimes it takes a while to get all the components to co-exist peacefully." -- Doug Vargas
Old 26th June 2002, 07:30
heiko_s heiko_s is offline
Junior Member
Join Date: Feb 2002
Location: Germany
Posts: 4
heiko_s is on a distinguished road
Baan: IV, ERP - DB: DB2 - OS: NT, Unix
@ all: thank you very much! ...

your suggestions helps me not only for this special case but for general understanding too!

thank you all!

Closed Thread

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Performance problems in tdinv0250m000 and MPS Erik Konrath Distribution, Transportation & Warehousing 6 30th March 2009 08:38
Baan Oracle* Driver Performance Problems pshaw1 Performance & Tuning 7 25th February 2004 15:27
Performance problems in session "Update Purchase Statistics" Erik Konrath Performance & Tuning 2 12th February 2003 11:14
Purchase Statistics Performance problems Erik Konrath Distribution, Transportation & Warehousing 1 4th February 2003 07:19

All times are GMT +2. The time now is 11:40.

©2001-2018 - -