Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Operating Systems & Databases

User login

Frontpage Sponsor

Main

Google search


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

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 31st July 2003, 19:31
terryw's Avatar
terryw terryw is offline
Junior Member
 
Join Date: Jun 2003
Location: Fort Wayne, IN
Posts: 18
terryw is on a distinguished road
Baan: IVc3 - DB: Oracle - OS: HP-UX
Lightbulb WinTel Server Configuration - Mirroring or RAID5

Our current environment is HP-UX\Oracle\Baan IVc3. We are moving to a Windows 2000\MS-SQL 2000\Baan IVc4 environment. We are licensed for 30 Baan users (and don't expect much growth), we run very little batch processing during the day, and are planning on implementing PDM after we complete the migration.

I am working with two different consulting groups, and they seem to differ greatly in their approach to configuring the server hardware.

The first consulting group is recommending a server with dual-Xeon 2.8Ghz processors, 4 GB RAM, and a sufficient amount of disk storage utilizing RAID5 technology. The OS, database, and Baan application would be installed in a single RAID5 drive array.

The second consulting group is recommending a server with the same CPU and RAM configuration, but they feel it is extremely important that we install the OS on a set of mirrored disks, do the same with the database (MS-SQL 2000) on a separate set of mirrored disks, and install the Baan application on a RAID5 disk array.

I'm curious what other shops with the same approximate user count have done when configuring their servers, and whether the second consulting groups approach is necessary for the application to perform in an acceptable fashion.

As a side note, we will be purchasing a second server for our Baan test environment, and this server will be configured IDENTICALLY to the production server. This approach to our test environment should allow us to perform in-depth testing at all levels, including the OS, database, and Baan application. The test server can also act as a "backup server", and we're also thinking about automating the updating of data on this server (from the production server), and using it to run some of our reporting.

All input/comments are GREATLY APPRECIATED!!
Reply With Quote
Sponsored Links
  #2  
Old 31st July 2003, 23:30
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
Our system is approximately same size as yours so should be quite representative. We don't have PDM but we do use PCF which is apparently quite system resource hungry.

When we went live with Baan (1999) we were advised to have storage setup more similar to your second scenario.

OS - mirrored
Baan APP- mirrored
DB - RAID 5
logs - mirrored

We have had other consultants since who have pretty much agreed so I would go with that. Although 1 consultant did suggest the use of RAID 0 for ( I think, it was a year ago so I can't quite say for certain) the logs to improve performance.

Not quite the same issue, but we have a system with redundant array controller and hot online spare disks - these have been a life saver!
Reply With Quote
  #3  
Old 1st August 2003, 08:35
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Any consultant his money worth will not only recommend a single setup, but is able to give reasons for it and compare it to alternatives.

Here is my view:

a) For performace reasons, I would recommand to have the database in a raid 0. Raid 5 will be more storage efficient, but without doubt always slower. With current prices for disk space, Raid 0 is the obvious choice. If you have the financial ressources, then you might consider putting the redologs on seperate disks.

b) Baan itself doesn't do a lot of IO (apart from accessing the database), so wether you put Baan in Raid5 or Raid 0 doesn't matter. Wether you put it on the same disks as the database or the OS doesn't matter, from a performance point of view.

c) From a maintainance and backup/recovery point of view, I would seperate the dynamic database from the more static components of your system, i.e. the OS and the applications.

d) From a crash recovery point of view, you might want to minimize your actuall boot disk/LUN, so that you can use tools like GHOST etc. to create an image of your system disk, which fits on a CD.

Regards

Markus

P.S.:Just out of curiosity, why are you moving from HP to WINTEL? We are operating both kind of systems and find maintaining BAAN/Oracle on Wintel a bit of a constraint:

- Did you find something similar to HP-Ux Ignite on Wintel?
- Dow do you open a 3 GB alertlog file on Wintel?

The first thing, I would do in your case, is to install cygwin. :-)

If you find good admin utilities on Wintel, then let me know.
Reply With Quote
  #4  
Old 1st August 2003, 10:41
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
RAID-0 on a production environment? Seriously? If one of your disks dies, you're whole environment becomes unusable and you will need to recover from backup. RAID-5 seems an absolute minimum to me.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2018 baanboard.com/baanforums.com
Reply With Quote
  #5  
Old 1st August 2003, 10:49
Markus Schmitz's Avatar
Markus Schmitz Markus Schmitz is offline
Guru
 
Join Date: Feb 2002
Location: Cyprus
Posts: 668
Markus Schmitz is on a distinguished road
Baan: Ivc4 - DB: Oracle8i/9i/10g - OS: HP-Ux11i
Hi Pat,

sorry, mistyped.

I meant Raid 0/1, ie. striped and mirrored.

Even on most test systems we mirror, because disks are cheap.

sorry again,

Markus
Reply With Quote
  #6  
Old 1st August 2003, 10:50
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
Ah that explains alot
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2018 baanboard.com/baanforums.com
Reply With Quote
  #7  
Old 11th February 2004, 17:55
vijendra vijendra is offline
Junior Member
 
Join Date: Jan 2004
Location: mICHIGAN
Posts: 12
vijendra is on a distinguished road
Baan: BaaN V - DB: oracle - OS: HP-UNIX
Post Baan PDM

Hi:

If you still need any assistance with Baan PDM please let me know at vjdr@hotmail.com
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
SQL Server 7.0 SP4 + BaanERP compatiblity Jabran Tools Administration & Installation 1 4th October 2004 11:49
Copying production server to development server.. r_nagu Operating Systems & Databases 2 13th August 2004 21:36
Wintel Users - Anyone Running Just RAID5? terryw Operating Systems & Databases 1 6th August 2003 22:46
Buying a new big Server or adding a little one beside the old? beksalur Operating Systems & Databases 6 10th March 2003 13:38


All times are GMT +2. The time now is 07:05.


©2001-2018 - Baanboard.com - Baanforums.com