Hello,

I have only 4-300GB SAS 10K RPM drives that are mirrored across 2 channels. I'm using RAW devices.

Any suggestions as to optimal dbspace layout in this IDS 11.7UC1GE instance on RHEL5.5 32-bit for OLTP?

I'm planning layout below:

disk 1. rootdbspace, phys log, logical log
disk 2. data1 (4 chunks 5GB/chunk)
disk 3. data1 (4 chunks 5GB/chunk)
disk 4. tempdb1, tempdb2

OR

disk 1. rootdbspace, phys log, logical log
disk 2. data1 (1 chunk 20GB)
disk 3. data2 (1 chunk 20GB)
disk 4. tempdb1, tempdb2

Thanks,
June Nebab




DISCLAIMER

This transmission and the information contained herein and/or in any attachments hereto and/or in any attachments thereto is privileged and/or confidential and is intended ONLY for the use of the individual(s) and/or entity(s) named above. If you are not the intended recipient, you are strictly prohibited from disclosing, printing, copying, using or disseminating this transmission and/or any such attachments and any information contained in this transmission and/or in any such attachments. ANY unauthorized interception of this transmission and/or any such attachments is a violation of federal criminal law.

If you have received this transmission in error, please notify the sender immediately and delete the transmission and all such attachments

My experience with direct-attached SCSI-3 drives has been that a single
large chunk performs slightly better that multiple small chunks.


On 21 January 2011 17:12, June Nebab LKINY <jnebab (AT) idealcut (DOT) com> wrote:


--


Nick Lello | Web Architect
o +44 (0) 8433309374 | m +44 (0) 7917 138319
Email: nick.lello at rentrak.com
RENTRAK | www.rentrak.com | NASDAQ: RENT