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



MS Sql Server LazyDBA home page