If you have SQL Enterprise, using different filegroups you can
use different theads for each filegroup.
So using different disks (for the operating system) is better,
you can have different queues en different disks.
Also the perfmon shows you more detailes info than having all
in an one disk.
If you have SQL Standard, it have no optimization for threads and
filegroups, so it is the same usign different disks that one big.
In this case, the only benefit for the administrator is the separation
of disks, and perfmon info.
RAID 1 or 5, dependes of your read/write rate. And how much disk space you
need.
It is better to have more SCSI disk channels, some boxes have partition
channels
and the disk controller can make RAID 1 or 5 using any channel, this is a
big
change in performance. I used it in some HP DL machines with big I/O bound
applications and in some operations you have twice the speed, in some RAID
1+0
combinations.
Regards,
Claudio.
-----Mensaje original-----
De: Smith Dano
[mailto:mssqldba-ezmlmshield-x37509654.[Email address protected]
Enviado el: Viernes, 25 de Febrero de 2005 12:04
Para: LazyDBA Discussion
Asunto: RE: Raid array for SQL
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]
---------------------------------------------------------------------
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