It always depends, but I would consider this..
Disks read/write is most often bound by number of disk "spindles".
Their suggestion is to use only 4 spindles at a time for "performance".
I suggest using all 8 in R5 configuration. Or even 7 with a hot-spare
disk.
7 Disks in R5 will out-perform 4 disk R1 any day...
Do you need superior performance? Or superior data protection ? R1 is
not a "Bad" idea, just over-cost and less performance in this case..(I
say over-cost because you will get less GB / $ in R1 )
And do you need more space?
Do you have enough capacity to restore all DBs onto same server with
existing DB's intact ?
This is my rule of desireable free space.
Dano
-----Original Message-----
From: Natalia Brett
[mailto:mssqldba-ezmlmshield-x68156170.[Email address protected]
Sent: Friday, February 25, 2005 4:01 AM
To: LazyDBA Discussion
Subject: Raid array for SQL
Importance: Low
Hello All,
Our company going to buy new server to use as SQL server.It will have 8
Disks 72Gb each.
Our engineers think to use "Raid1 plus 0" and build 1 huge virtual disk.
Currently we have RAID 1 built on 6 disks so it is 3 disk available.
Each database has a few File groups : disk1 - data1.mdb; disk2 -
data2.mdb + index1.ndf; disk3 - index2.ndf + tran.log
I have put in different files tables (each more then 5'000'000 records)
which offen used in a join statements and it really improved
performance.
How it will work on "Raid1 plus 0"?
Regards,
Natalia
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
The information within this e-mail is confidential and intended solely
for the use of the recipient(s). If you are not the intended recipient
then please notify Natalia Brett via email at Natalia.[Email address
protected] or by telephone on +44(0)1244 319912. Then delete the email
from your system. Please do not read, copy, print, forward, disclose, or
use the information contained within this email. Note that any views or
opinions presented in this email are solely those of the author and do
not necessarily represent those of Aktiv Kapital. Finally, the recipient
should check this email and any attachments for the presence of viruses.
The company accepts no liability for any damage caused by any virus
transmitted by this email.
Aktiv Kapital (UK) Ltd
Merchants House
Hamilton Place
Chester
CH12BE
UK
www.AktivKapital.co.uk
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page