2012年3月29日星期四

disks when doing mirroirng

Hi,
I'm using SQL 2005 with 2 identical servers
I want to use Mirroring between the two.
I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
services)
each server has 6 disks.
what is the best configuration of these disks ?
3 RAID1, 1 RAID1 + RAID5 ?
and where should i put things ?
e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
If all drives are the same size and type, for fault tolerance:
1- Mirror of two disks for OS and SQL Server
2- Create two mirrors (2 drives each) and then create a stripe with parity
between both mirrors (RAID 0). I will put the data and log files there.
This way, you can have 3 failed disks (one failed disk on each mirror) and
the system will still be online. Also RAID 0 will give you better performance.
Another option would be to create a RAID 5 with for the data and the files,
which will give you a good performance for reads (not as good for wites..)
and you will be having more space for storage for the data and the logs,
compared with the first option
"raviv762@.gmail.com" wrote:

> Hi,
> I'm using SQL 2005 with 2 identical servers
> I want to use Mirroring between the two.
> I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
> services)
> each server has 6 disks.
>
> what is the best configuration of these disks ?
> 3 RAID1, 1 RAID1 + RAID5 ?
> and where should i put things ?
> e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
>

没有评论:

发表评论