Make two arrays RAID-1 for system RAID-10 for other
About DB there is need additional arrays and do tests, because it depends of your data and load, usualy at least you need three or more arrays, one for tempdb, one for data and one for logs. You may move tempdb on same disk with OS, and data and logs on second array? or move logs on raid1 too, Anyway you have very few disks and you need need some compromise. Foxpro relevant to FileServer functions and there same requrements, also for FoxPro more important LAN then disk system. I I advice get contult with professionals. Advice above only common advice, except separate array for OS And install more memory as possible, but at least 4 gb - it is most important factor for SQL Server. Best regards, Anatoly Podgoretsky ----- Original Message ----- From: Joe Heaton To: NT System Admin Issues Sent: Wednesday, April 02, 2008 6:17 PM Subject: DB server RAID 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] ~ Upgrade to Next Generation Antispam/Antivirus with Ninja! ~ ~ <http://www.sunbelt-software.com/SunbeltMessagingNinja.cfm> ~
