Hardware/RAID Optimum Setup

I need some help with configuring SQL2K on a brand new machine.
The machine has 6 disks. RAIDx is required (I know more or less nothing
about RAID). My database has one table in particular which is hammered
non-stop.
So, I put the table that is used incessantly on one disk, the transaction
log on another and the data file on another. Does this make sense and what
options would that give me for RAID ?
Thanks
FrankNormally I would give a detailed answer to this but home
time here and I give a life to somebody.
Email me on peternolan67REMOVETHIS@.hotmail.com, nd I wil
go through all the options, rather than the best, its more
a case of the best for your circumstances.
Peter
MCDBA
"A politician needs the ability to foretell what is going
to happen tomorrow, next week, next month, and next year.
And to have the ability afterwards to explain why it
didn't happen."
Winston Churchill
>--Original Message--
>I need some help with configuring SQL2K on a brand new
machine.
>The machine has 6 disks. RAIDx is required (I know more
or less nothing
>about RAID). My database has one table in particular
which is hammered
>non-stop.
>So, I put the table that is used incessantly on one disk,
the transaction
>log on another and the data file on another. Does this
make sense and what
>options would that give me for RAID ?
>Thanks
>Frank
>
>.
>|||Hi Frank
Is your database and OLTP or an OLAP system?
The strategy for RAID is highly dependent on you query types.
Yours sincerely
Thomas Kejser
M.Sc, MCDBA
"Frank Ashley" <aa@.aa.com> wrote in message
news:O9woh4y9EHA.3260@.TK2MSFTNGP14.phx.gbl...
>I need some help with configuring SQL2K on a brand new machine.
> The machine has 6 disks. RAIDx is required (I know more or less nothing
> about RAID). My database has one table in particular which is hammered
> non-stop.
> So, I put the table that is used incessantly on one disk, the transaction
> log on another and the data file on another. Does this make sense and what
> options would that give me for RAID ?
> Thanks
> Frank
>|||Its OLTP
Thanks
Frank
"Thomas Kejser" <thomas@.kejser.org> wrote in message
news:OhLA5I09EHA.3236@.TK2MSFTNGP15.phx.gbl...
> Hi Frank
> Is your database and OLTP or an OLAP system?
> The strategy for RAID is highly dependent on you query types.
>
> --
> Yours sincerely
> Thomas Kejser
> M.Sc, MCDBA
>
> "Frank Ashley" <aa@.aa.com> wrote in message
> news:O9woh4y9EHA.3260@.TK2MSFTNGP14.phx.gbl...
>>I need some help with configuring SQL2K on a brand new machine.
>> The machine has 6 disks. RAIDx is required (I know more or less nothing
>> about RAID). My database has one table in particular which is hammered
>> non-stop.
>> So, I put the table that is used incessantly on one disk, the transaction
>> log on another and the data file on another. Does this make sense and
>> what options would that give me for RAID ?
>> Thanks
>> Frank
>>
>|||"Frank Ashley" <aa@.aa.com> wrote in message
news:O9woh4y9EHA.3260@.TK2MSFTNGP14.phx.gbl...
>I need some help with configuring SQL2K on a brand new machine.
> The machine has 6 disks. RAIDx is required (I know more or less nothing
> about RAID). My database has one table in particular which is hammered
> non-stop.
> So, I put the table that is used incessantly on one disk, the transaction
> log on another and the data file on another. Does this make sense and what
> options would that give me for RAID ?
> Thanks
> Frank
>
A quick search through the NG will give you this answer. Here it is again
however...
RAID Levels and SQL Server:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_79pv.asp
Rick Sawtell
MCT, MCSD, MCDBA