What they mean by that was actually addressed yesterday. It means you should have your logs on a separate array from your databases. The reason for this is that logs are an incremental process, meaning there's not much read/write head movement on the disks. The databases are non-incremental, meaning the read/write head is hopping all over the place on the disk. Which means, as stated, you should have these processes separated, in order to maximize your read/write efficiencies. Joe Heaton
________________________________ From: David Florea, SysAdmin [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 5:30 PM To: NT System Admin Issues Subject: RE: DB server RAID Late getting to this thread, I know, but can you expand on 'segregate your I/O'? Thanks, David ________________________________ From: Sean Martin [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2008 8:49 AM To: NT System Admin Issues Subject: Re: DB server RAID Unfortunately, you're pretty limited with only 6 drives. Typically, you'd want a separate array for OS, Logs, and DBs. With the hardware you have available, your best bet would be to go with three RAID 1 Arrays (OS, Logs, DBs). Hopefully 146Gb is enough space to host your DBs. The most important thing to remember is to segragate your I/O. - Sean On 4/2/08, Joe Heaton <[EMAIL PROTECTED]> wrote: What's the "industry standard" setup for RAID on a database server? I have a Dell PE2950, with 6 146GB SAS drives, which I believe have come from the factory in a RAID5. Was just wondering if I should redo the RAID into a RAID10 situation, which I understand has the best I/O performance. The databases will be SQL, although I believe we'd also be moving an old Foxpro database over. Joe Heaton AISA Employment Training Panel 1100 J Street, 4th Floor Sacramento, CA 95814 (916) 327-5276 [EMAIL PROTECTED] ______________________ The information contained in this E-mail message, including any attached files transmitted, is confidential and may be legally privileged. It is intended only for the sole use of the individual(s) named above. If you are the intended recipient, be aware that your use of any confidential or personal information may be restricted by state and federal privacy laws. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute or forward this E-mail message. If you have received this E-mail in error, please notify the sender and delete the material from your computer system. This message is provided for information purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments in any jurisdiction. ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
