Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > Performance & Tuning

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Closed Thread
 
Thread Tools Display Modes
  #1  
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,
Heiko
__________________
Heiko
IBM
  #2  
Old 20th June 2002, 11:57
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
Heiko,

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.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
  #3  
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
  #4  
Old 24th June 2002, 19:40
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Hieko,

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

Quote:
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:
CPU LOAD USER NICE SYS IDLE BLOCK SWAIT INTR SSYS
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/45

CPU TTY PID USERNAME PRI NI SIZE RES STATE TIME %WCPU %CPU COMMAND
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
  #5  
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
__________________
Jim VanderMey
VP of Technical Operations
Open Systems Technologies
Grand Rapids, Michigan, USA
jvandermey@ostusa.com
  #6  
Old 25th June 2002, 17:10
Francesco's Avatar
Francesco Francesco is offline
Guru
 
Join Date: Aug 2001
Location: Antwerp, BE
Posts: 727
Francesco is on a distinguished road
Baan: 5b - DB: Oracle - OS: Solaris
My two cents

Heiko,

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)
__________________
Cheers,

Francesco
..............................................................

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
Sponsored Links
  #7  
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!

heiko
__________________
Heiko
IBM
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 00:07.


©2001-2017 - Baanboard.com - Baanforums.com