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
FrankHi 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...
>|||"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/e..._tun_1_87jm.asp
Comparing Different Implementations of RAID Levels:
http://msdn.microsoft.com/library/e..._tun_1_79pv.asp
Rick Sawtell
MCT, MCSD, MCDBA