Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Netherlands
    Posts
    1

    Unanswered: Best Performance Strip setting RAID

    We are running SQL6.5 and plan to upgrade to SQL2000. I'm wondering what's the best stripe size for the RAID 5 configuration. 8,16,32 or 64 kb.
    The database is 90% used for read actions. Only during night complete refill of data and write actions only for statistics. Any advise is welcome on this subject

  2. #2
    Join Date
    Apr 2002
    Posts
    7
    Since SQL server pages are 64K the raid stripe settings must also be set to 64K

  3. #3
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    SQL 6.5 uses 2k pages and SQL 2000 uses 8k pages.

    The stripe size of your RAID drives does NOT have to follow the page size, however I would use a RAID stripe size >= to my page size.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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