Re: Can SAPDB handle databases up to 500 GB and which hardware is required?

[Detlef Schulze]

As a general rule of thumb for database servers:   Never use Raid Level 5 for a database server. Level 5 gives you bad performance. Use Level 10 instead (striped mirror) if you want to use a Raid.   If you can, use raw devices. Raw devices have some drawbacks though (You cannot use simple OS commands on a raw device for copying data etc.)   Use lots of Shared Memory. Usually you configure your kernel to use 50 % of the available memory for Shared Memory, sometimes more.     hth Detlef ----- Original Message ----- From: Horst Rohrweck To: [EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 9:03 AM Subject: Can SAPDB handle databases up to 500 GB and which hardware is required? Hi all,   I’ve got a project where I have to design a database with an approximately size of 500 GB and possibly even more. The hardware which I planned for the database is an Intel Server Board equipped with 8 GB of DDR RAM, two Intel Xeon processors with 2,8 GHz and an Intel RAID Controller (PCI 64) with U320-SCSI IBM harddisks in a RAID 5 compound structure. As OS I plan to use Linux with a modified 2.4 kernel. Does anyone have experiences with database sizes like this? Is the hardware of my database machine sufficient to guarantee fast response times of queries (mainly simple SELECT statements)? Thanks in advance, Horst