Re: dbspace planning

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@idealcut.com> wrote: > 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. > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > -- 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