SQL Server Performance

SAN Stripe size - 64k or 128k

Discussion in 'Performance Tuning for Hardware Configurations' started by simondm, Sep 29, 2004.

  1. simondm New Member

    Hi,

    My company is in the planning stage of moveing our SQL environment onto a an EMC CX700 SAN.

    EMC have suggested for the SQL drives (data & logs) that we use a stripe size of 128k. I do not know how in tune with SQL they are...

    Historically on SCSI devices we've always used 64k - 8k pages, 8 pages to an extent blah blah.

    As 128 is a mulitple of 64 I can understand 128 being suitable. Does anyone have any opinions or know of any testing for this?

    Any advice greatly appreciated!

    Thanks
    Simon
  2. joechang New Member

    128K is a reasonable stripe size at the RAID controller level,
    i would suggest that you get the vendor to guarantee a certain random and sequential read/write IO rates the storage array you purchase will achieve.

    i have seen too many expensive SAN solutions that achieve worse performance than a single notebook hard drive.
    use IOMeter (developed by intel, now on sourceforge.net) to test the disk array.
    i will probably provide SQL scripts for for generating random and sequential IO patterns in the near future

  3. simas New Member

  4. simondm New Member

    It would seem EMC do actually recommend 64k for SQL Server. However, I still intend to test this once it is up and running using Simas' tool.

    Thanks for the help.
  5. avkesq New Member

    In the CX700, a stripe size of 128 actually indicates 128 clusters which amounts to 64K. So you are both talking about the same thing in different languages.

    Read the RAID section (Section 2) of the CX700 Storage systems configuration and planning guide available on the Dell web site.
  6. peterlemonjello New Member

    A little of topic... I'm not sure the CX700 has the same issue as the CX300 but if so make sure you correct the disk offset when you create your LUNS.

    We use 128 stripe size with our CX300's and CX700's.

Share This Page