DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Advice on RAID ?

  1. #1
    Join Date
    Sep 2002
    Posts
    12

    Advice on RAID ?

    Hi All,
    I have a new xeon server & ruinning win2kserver. have a storage array that comes to 657 gb. 4 gigs of ram

    10 disks of 73 gigs each.

    my scenario is:

    - data warehouse & data mining
    - can afford a down time
    - have less number of users (less than 20)
    - lots of full table, scans, huge joins (ie. lots of reads)
    - need seperate table space for users to create tables and drop them and so on.

    please suggest me some configurations.

    raid 0 or raid 3 or raid 5


    ks

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    RAID 5
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Can you create/update most of your stuff with NOLOGGING (think about recovery)? If so, RAID5 for everything.
    If you have massive logged changes, get hold of a couple of little disks (theft works quite well) and put your redo logs (and control files?) on RAID1, with nothing else on the same drive. All the rest RAID5.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width