General discussion

  • Creator
    Topic
  • #2259371

    2Controllrs-HPUltra320-Dual & 641Array

    Locked

    by jackiestinson ·

    2 Controllers in Proliant ML350G4P-HPUltra320-Dual & 641 Array-Optimal Configuration?-Have 5-72GB Drives and Ultrium230i Tape drive.
    All Hard-drives to the 641 Controller(1 Cable) and the Tape drive on On-Board Controller.
    The Vendor asks for the following(We have Windows 2003 Std R2 and SQL 2000 Server). They say SQL s/b configured utilizing 3 physical drives(1st Drive for System Files)(2nd for Data Files)(3rd houses Log Files). Is this the optimal way for SQL, or is Raid 5 going to be just as fast. Before I run Smart Start, I thought I should get opinions. We will be backing up Full Nightly

All Comments

  • Author
    Replies
    • #3206673

      Reply To: 2Controllrs-HPUltra320-Dual & 641Array

      by cmiller5400 ·

      In reply to 2Controllrs-HPUltra320-Dual & 641Array

      I would definately be running in some sort of redundant configuration. If it were me, I would create a RAID5 array (RAID5e if the controller supports it) and then Partition 3 drives off of the array. Performance will be degraded on the RAID5 if you have alot of writes to the database, the reads however will be faster (this is a known fact of RAID5 arrays) Make sure that you designate one of the drives as a hot spare so that if one fails, it will automatically start the rebuild. This will give you about 216GB of storage space configured in a RAID5 array with hot spare.

Viewing 0 reply threads