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
38%
Installation Wizard into new VRC
41%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 37

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 6th March 2009, 21:03
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
slow Baan performance
Baan: Baan IVc4
DB: SQL Server 2000
OS: Windows 2003
C/S: Both

Hi Guys,

I would like to solicit your opinion on our Baan server setup as we are currently facing
performance issue especially on Sales Invoicing, Service Invoicing and Generating Projects
from Sales Order. On a bad day a single invoice can take up to 3 minutes to print. We have
around 250 users. Baan 4C4 SP20 app and database (SQL Server 2000 Enterprise SP4) is in the same Server. We have
windows 2003 Enterprise Edition R2 SP2. We have 24 GB RAM. We have four dual-core Intel Xeon
processors. SAN-connected. We have 125 GB database used. We are also heavy users of SQL
Reporting Services and have job running on Intergratio Package in early morning. We use
Taxware. Our CPU utilization could come up to 96% in the middle of the day. We do experience
better speed in the morning and late afternoons when there are less users.
Reply With Quote
  #2  
Old 7th March 2009, 18:00
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
performance

As the complaint is more about print sessions than process sessions like tdsls4223 , tfgld4200s000 tfgld1212s000 etc , I assume u have database properly tuned , update statistics run periodically .

Directions u can look for can be

1. U did not specify network usage . Is speed of NIC , switch , cabling etc any bottleneck . Normally gigaport switch and nic , cat 6 cabling will not have network bottleneck.

2. Printing normally has to deal with writing in tmp . If tmp is not cleared for quite some time , then printing / login etc can be slow .

3. As u use reporting service , u may not be using baan reporting substantially . Still check if u have lot of disk based data transformations used in Baan reporting and Baan proceses for summarizing / compressing data and such reports / programs run regularly daily .If yes , then u can speed up the system by using memory based algorithms in such reports / programs.

4. What is the number of records in invoicing related tables like tdsls040/1/5/50/1 , tsssma tables and number of customers u talk about . Is there possibility to archieve such sales data to archieve company . That will definitely improve the performance of invoice printing.

5. Do u have large number of companies . If yes , do u share tables for modules which arenot used e.g. we did not used tp , tr modules . We shared all such tables . So in our case , for each new company the number of tables created at db level were only 500 as against 2500 . DB catalogue size greatly reduces with table sharing (of course without compromising functionality ) .

6.What is the make up ntbshell , mslsqldriver and reporting services in overall server load . mssql and reporting services are resource intensive and not releasing the resources when needed . Is it possible to reduce the allocations of memory / cpu resourses so that more resources are available to ntbshell.

7. Run TSQLs to get most time consuming SQL in runtime in enterprise manage at the time of peak loads.

8. Use baan traces to get driver related traces .
Reply With Quote
  #3  
Old 25th March 2009, 17:09
Dikkie Dik's Avatar
Dikkie Dik Dikkie Dik is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 585
Dikkie Dik is on a distinguished road
Baan: Triton 3.0 and higher - DB: All - OS: All
Hitesh mentioned a lot of things. Maybe I can add some more:

- Check your IO. As you do a lot of reporting stuff, this could put a heavy load on your disks.

- I would normally start with a Call Graph Profile. It shows you where your time is spend: CPU, queries or other things.

- I also recommend to make a system wide trace with e.g. perfmon. It can tell you the most consuming processes.

- Last but not least I recommend to check the database. Your report services can ruin your cache. This definitely helps to slow down normal users.

hope this helps,
Dick
__________________
BTW: this post has been made on my personal view. My employer might not share my point of view.
Reply With Quote
  #4  
Old 10th April 2009, 16:52
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Hi,

Just to add up to the above points ..

Assuming the OS is 32 bit - the DB shall consume only 4 GB limit even though you have 24 GB , You might need to increase System global area size (check with SQL DB) .

hence moving DB (DB only) into seperate server (64 bit OS) and increasing the SGA / pool size etc...might work.



BR,
Sushil Kumar Mudaliar

Last edited by sushil : 15th April 2009 at 07:31.
Reply With Quote
  #5  
Old 11th April 2009, 11:26
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
win2k3 ent edition

I think it's possible to use more memory with some pab boot switch in win2k3 enterprise edition. In 64bit there is no need for such boot switch to enable more memory utilization.
Reply With Quote
  #6  
Old 13th April 2009, 06:52
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Hi,

Please be informed , PAE can be used in boot switch - (Physical address ext) for 4GB above support.

But it is only for WINDOWS OS not for Database i.e even if you use PAE - you will not be able to configure your Db for above 4 GB.

BR,
Sushil Kumar Mudaliar.
Reply With Quote
Sponsored Links
  #7  
Old 13th April 2009, 07:14
sushil's Avatar
sushil sushil is offline
Guru
 
Join Date: Jan 2006
Posts: 451
sushil is on a distinguished road
Baan: BAAN IV C4 - DB: Oracle - OS: Windows
Since your DB is SQLSERVER from Microsoft - you could try AWE in conjunction with PAE.

http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx

Hope this helps.

BR,
Sushil Kumar Mudaliar
Reply With Quote
  #8  
Old 13th April 2009, 15:50
Hitesh Shah's Avatar
Hitesh Shah Hitesh Shah is offline
Guru
 
Join Date: Nov 2001
Location: Mumbai,India
Posts: 1,855
Hitesh Shah is on a distinguished road
Baan: triton,Baan IVc4 , ERP Ln - DB: Oracle/Bisam/SQL 2000/SQL 2005 - OS: Sun Solaris/Windows 2003
More memory for SQL

Right . SQL can have more memory available with PAE & AWE . One more link for the same http://www.modhul.com/2007/11/10/opt...server-part-i/ besides authentic one from MS .
Reply With Quote
Reply


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
Baan Administrator Christina Gampa Jobs and Resumes 0 10th January 2008 11:26
Baan Tools Administrator Muhammad Ali Jobs and Resumes 0 27th June 2007 10:49
Senior Baan Administrator OneNeck IT Svcs Jobs and Resumes 0 15th February 2007 19:11
Baan IVc2 and Oracle 8.1.7 performance problem mpenno Performance & Tuning 2 3rd September 2003 19:50
Is Invensys really planning to sell Baan? baanassist General Discussion & Chat 10 3rd September 2002 19:29


All times are GMT +2. The time now is 17:10.


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