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 ..
>|||Is your database OLTP? ... if not, you can setup your server like this:
RAID 1 (2 disks) = Os
RAID 5 (4 disks) = Data and Log files
If your data is not static, then ...
RAID 1 = Os
RAID 1 = Data Files
RAID 1 = Log Files
Using this last config. you won't have a high availability option like
RAID 5 for your data but you'll have a better performance for your
transactions and log files...
Edgardo wrote:
> 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 ..
> >
> >|||thanks for the quick answer.
some remarks and a question ...
1) i can not do RAID10 since my disks are not so big ... and i can not
buy bigger.
2) my data is not static, so i guess the second option is better.
the high availability will be supported by the mirroring between
servers so i'm relaxed on that.
do you have recomendation were to put the SSIS, Reporting services,
tempDB ?
jocamp3@.gmail.com wrote:
> Is your database OLTP? ... if not, you can setup your server like this:
> RAID 1 (2 disks) = Os
> RAID 5 (4 disks) = Data and Log files
> If your data is not static, then ...
> RAID 1 = Os
> RAID 1 = Data Files
> RAID 1 = Log Files
> Using this last config. you won't have a high availability option like
> RAID 5 for your data but you'll have a better performance for your
> transactions and log files...
>
> Edgardo wrote:
> > 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 ..
> > >
> > >sql