The best raid configuration for the SQL Server?

29/09/2008 - 13:34 von Wolfgang Bauer | Report spam
Hello,



I have a problem choosing the right raid configuration for a small two
server solution with about 90 users (light collaboration).



The SQL server has eight SAS hard disks.





Two disks are needed for a raid 1 for the operating system, so I have six
disks left.



I figured out three possible configurations:



- Two raid 5 devices with three disks each. One for the logs and one for the
database files.

- One raid 5 with six disks.

- Or one raid 1 for the logs and a raid 10 for the database files.





Three disk raid 5 configurations might have not enough power

One big raid 5 is violating against the SQL recommendations of dividing logs
and data.

The Raid 1+10 solution might have not enough power for the logs.





What is the best solution with eight SAS disks and why?





Thanks,



Wolfgang Bauer
 

Lesen sie die antworten

#1 Wolfgang Viehmann
01/10/2008 - 16:10 | Warnen spam
Hallo Wolfgang,

Ich würde die folgende Kombination wàhlen:

1 x RAID-1 für das Betriebssystem
1 x RAID- 5 für die Log-Dateien
1 x RAID- 5 für die Datenbank-Dateien

Gründe:

Sowohl das Betriebssystem als auch Log-Dateien und Datenbank-Dateien sind
auf redundanten Datentràgersystemen gespeichert.

Folgende informativen Links zum Thema:

http://msdn.microsoft.com/de-de/lib...90764.aspx

http://msdn.microsoft.com/de-de/lib...84252.aspx

http://msdn.microsoft.com/de-de/lib...88252.aspx

http://msdn.microsoft.com/de-de/lib...78048.aspx

http://technet.microsoft.com/de-de/...98801.aspx

Wolfgang Viehmann
(Wolle)
"Wolfgang Bauer" <Microsoft.public.opsmgr.sp1> wrote in message
news:
Hello,



I have a problem choosing the right raid configuration for a small two
server solution with about 90 users (light collaboration).



The SQL server has eight SAS hard disks.





Two disks are needed for a raid 1 for the operating system, so I have six
disks left.



I figured out three possible configurations:



- Two raid 5 devices with three disks each. One for the logs and one for
the database files.

- One raid 5 with six disks.

- Or one raid 1 for the logs and a raid 10 for the database files.





Three disk raid 5 configurations might have not enough power

One big raid 5 is violating against the SQL recommendations of dividing
logs and data.

The Raid 1+10 solution might have not enough power for the logs.





What is the best solution with eight SAS disks and why?





Thanks,



Wolfgang Bauer


Ähnliche fragen