<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic SQL Server 7.0 and Stripe Size in Disk Enclosures</title>
    <link>https://community.hpe.com/t5/disk-enclosures/sql-server-7-0-and-stripe-size/m-p/2500744#M1398</link>
    <description>Wanted some information about the proper Stripe Size to set for each raid.  I have two 5302 controllers in a Proliant 8000.  On controller one, I have a Raid 0+1 set that defaulted to a 128kb Stripe Size, then a 70GB Raid 5 that defaulted to a 16kb (I changed it to 32kb).  The second controller has a single 70GB Raid 7 also defaulted to 16kb (I changed to 32kb).  What is the proper Stripe Size for a system with 65% read to 35% write system.   Would I get any performance lift by changing the RAID 5's to 32kb or should I have left it at 16kb.  Also the Raid0+1 will have write heavy tempdb on it.  Should this be lowered?   Please let me know if there are any documents that can help.  I would also appreciate some suggestions.  This system is still in the setup and testing stage so it can easily be rebuilt.  &lt;BR /&gt;  &lt;BR /&gt;THANKS,  &lt;BR /&gt;  &lt;BR /&gt;TONY A.</description>
    <pubDate>Mon, 05 Mar 2001 00:00:00 GMT</pubDate>
    <dc:creator>Ayman Altounji</dc:creator>
    <dc:date>2001-03-05T00:00:00Z</dc:date>
    <item>
      <title>SQL Server 7.0 and Stripe Size</title>
      <link>https://community.hpe.com/t5/disk-enclosures/sql-server-7-0-and-stripe-size/m-p/2500744#M1398</link>
      <description>Wanted some information about the proper Stripe Size to set for each raid.  I have two 5302 controllers in a Proliant 8000.  On controller one, I have a Raid 0+1 set that defaulted to a 128kb Stripe Size, then a 70GB Raid 5 that defaulted to a 16kb (I changed it to 32kb).  The second controller has a single 70GB Raid 7 also defaulted to 16kb (I changed to 32kb).  What is the proper Stripe Size for a system with 65% read to 35% write system.   Would I get any performance lift by changing the RAID 5's to 32kb or should I have left it at 16kb.  Also the Raid0+1 will have write heavy tempdb on it.  Should this be lowered?   Please let me know if there are any documents that can help.  I would also appreciate some suggestions.  This system is still in the setup and testing stage so it can easily be rebuilt.  &lt;BR /&gt;  &lt;BR /&gt;THANKS,  &lt;BR /&gt;  &lt;BR /&gt;TONY A.</description>
      <pubDate>Mon, 05 Mar 2001 00:00:00 GMT</pubDate>
      <guid>https://community.hpe.com/t5/disk-enclosures/sql-server-7-0-and-stripe-size/m-p/2500744#M1398</guid>
      <dc:creator>Ayman Altounji</dc:creator>
      <dc:date>2001-03-05T00:00:00Z</dc:date>
    </item>
  </channel>
</rss>

