Hello, > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Samstag, 9. M�rz 2002 16:41 > To: [EMAIL PROTECTED] > Subject: Harddrive layout recommendation. > > > I'm currently setting up a SAPDB for production on a E250 Sun > server. I have four 36GB harddrives in the system, and the system has > 2GB of ram. This system will only be used to run this database and no other > applications. > > I was planning on having the logdev on the same drive as the > OS hmmmm... Normally, since all transaction commits have to wait for the log to be written on disk, the log should be written to a separate disk. The log disk is the most important for performance!
> and the data, sys and all others on the other harddrive. > > Then I was going to mirror the other two harddrives with the first two > in a RAID 1 configuration. that is fine, but there is a dilemma. With your RAID1 you end up with only two separate disks each 36GB. 36GB is quiete a big log device, if your data device has only 36GB capacity. If you want to place the log on a separate disk you would have only one disk for data and the system. But you would also like to separate the system and the data... I would recommend you keep your RAID1 configuration for security reason, but put the system and the data (not the log) on two separate partitions (using rawdevice for data) on the first 36GB mirrored disk. The second mirrored disk i would split (see above) into a log partition (rawdevice) and a data partition. This allows to have to data partitions on saparate disks which enhances data I/O throughput and still no conflict with system activity (i.e. backup on file....). The conflict between data and log is not nice, but better than a conflict with system activity - even if you have a dedicated database server. It would be better, to have extra disks for the system, data and log, but this seems to be the best choice without hardware modifcation. > > The database will only be accessed by a web server with > JDBC, possibly other web servers in the future. Does anyone have any > recommendations on this setup, any help would be appreciated. > > Thank You, Your welcome. CU jrg _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
