[windows2000] SV: RAID

  • From: "Svein Arild Haugum" <svein@xxxxxxxxxxxxxx>
  • To: <windows2000@xxxxxxxxxxxxx>
  • Date: Fri, 10 Oct 2003 19:18:40 +0200

If you use RAID 5, ony use it for the database files.
A normal decent SQL Server would be:
RAID 1 for opsys and pagefile (sql doesnt page much, its ok to have this on one 
disk, use 1,5 the memory for the pagefile as a starter)
RAID 1 or raid 10 for the logs, a raid 1, wich you use ONLY for logs is quite 
decent, since the drive alvays stays in the right place ro write....
RAID 1 (good, but expencive), RAID 10 (Really good) and RAID5 (Cheap) for the 
Remember for format the LOG and Data drives with 64KB clusters.
If you can afford, use one RAID controller per array. If not use different 
channels if possible.
I have som good tuning hardware, opsys and databases papers for sql server, 
mail me off the list if you want them. (Probably cant give them before monday)

Svein Arild 

-----Opprinnelig melding-----
Fra: Bill Beckett [mailto:Bill.Beckett@xxxxxxxxxx]
Sendt: 10. oktober 2003 16:42
Til: 'windows2000@xxxxxxxxxxxxx'
Emne: [windows2000] RAID

Just wanted to get the lists opinion on this. 

We have RAID 5 for several of our servers. However, our database server is 
going to be rebuilt and I have read several articles saying that RAID 5 is not 
a good choice for a DB server. What would you guys recommend for a DB Server?

Other related posts:

  • » [windows2000] SV: RAID