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

Reply
 
Thread Tools Display Modes
  #1  
Old 29th November 2003, 10:28
Bulletboy Bulletboy is offline
Junior Member
 
Join Date: Nov 2003
Posts: 5
Bulletboy is on a distinguished road
Baan: IV c4 - DB: SQL - OS: NT4 SP4
Baan Server Configs and server loads

Hi all
I am pretty new to Baan and our company has a Baan IV c4 installation running on Windows NT SP4 on the following hardware

Dual P III Xeon 500
1 GB RAM
8x9.1 GB SCSI'S in RAID 5
2 GB Swap on 80GB IDE drive

We have about 25 Active concurrent users and during most of the day our CPU's are maxed out by SQL. When all 25 users are online,performance is really slow.

Just curious about what sort of loading other Baan Servers out there are running at.

Would be really nice to know what people are running

Hardware config.
Users
Typical Server Load

Thanks!
Reply With Quote
  #2  
Old 29th November 2003, 11:08
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
SQL version

I presume you are on SQL 7 or above. If on SQL 6.5, that had very poor performance!
Reply With Quote
  #3  
Old 30th November 2003, 09:55
N. sriram N. sriram is offline
Junior Member
 
Join Date: Mar 2003
Location: India
Posts: 24
N. sriram is on a distinguished road
Baan: b40c4 - DB: sql 7.0 - OS: winnt
server load

Same problem with me too. I have only 16 concurrent users.
I've moved all report generation outside of baan (in crystal reports), so much of server load is taken out.

mostly reports need a lot of processing, everytime a big report is generated the CPU usage comes to 100%, which also makes other processes slow. RAID5 also is instrumental in making the server slower.

sriram
__________________
N. Sriram
Gabriel India Limited
Nasik-India
Reply With Quote
  #4  
Old 1st December 2003, 06:09
Bulletboy Bulletboy is offline
Junior Member
 
Join Date: Nov 2003
Posts: 5
Bulletboy is on a distinguished road
Baan: IV c4 - DB: SQL - OS: NT4 SP4
Re: SQL version

Quote:
Originally posted by EdHubbard
I presume you are on SQL 7 or above. If on SQL 6.5, that had very poor performance!
Yes we are using SQL 7 and performance is poor. SQL eats up around 800MB or so of physical memory during peak loads.

Quote:
Originally posted by N. sriram

RAID5 also is instrumental in making the server slower.
I am not sure that the RAID 5 is the cause of the server slowing down (assuming that you have a good RAID card installed that does not eat CPU cycles.Even in the worst case a RAID card would not consume more than 10% of CPU time even under extensive read/writes)
I setup a performance counter in winNT and under peak loads the reads/writes total did not exceed a few hundred Kbytes/sec. (far below the capability of the Disk subsystem, even an old one such as the one we have)

I have a feeling that memory is the bottleneck. Today i will set up another perfomance counter to see how much swapping takes place under load for a few days.

could you ( EdHubbard and sriram and anyone else who reads this post) also please post some numbers about Disk I/O's and memory usage in your systems under a typical load? Just so that the bottleneck is easier to isolate

Thanks!
Reply With Quote
  #5  
Old 1st December 2003, 12:13
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
Memory

Our server physically has 1.7GB of RAM. The SQL process uses around 1GB of that so I think your memory is likely to be too low.
We have 4 x 400MHz Xeon processors and processor utilization averages 30%.
Reply With Quote
  #6  
Old 1st December 2003, 13:22
Bulletboy Bulletboy is offline
Junior Member
 
Join Date: Nov 2003
Posts: 5
Bulletboy is on a distinguished road
Baan: IV c4 - DB: SQL - OS: NT4 SP4
EdHubbard <--- How many concurrent users are on your server typically ?
Reply With Quote
  #7  
Old 1st December 2003, 13:27
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
Typically 25 - 30 users
Reply With Quote
Sponsored Links
  #8  
Old 1st December 2003, 13:37
Bulletboy Bulletboy is offline
Junior Member
 
Join Date: Nov 2003
Posts: 5
Bulletboy is on a distinguished road
Baan: IV c4 - DB: SQL - OS: NT4 SP4
Hmm interesting....you are probably right about the memory being too low. I am going to start some perf logs to monitor the Pagefile usage.

Low physical memory would translate to higher Paging right?
Reply With Quote
  #9  
Old 1st December 2003, 13:53
EdHubbard's Avatar
EdHubbard EdHubbard is offline
Guru
 
Join Date: Mar 2002
Location: Malvern, England
Posts: 309
EdHubbard is on a distinguished road
Baan: 4c4 MCR - DB: MS SQL Server 2000 - OS: Windows 2003 Server
I think so. Our test server only has 1.2GB of RAM and it works ok - but it only has 1 or 2 users on at any time.
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


All times are GMT +2. The time now is 09:29.


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