Results 1 to 2 of 2

Thread: Sybase and SAN

  1. #1
    Join Date
    Sep 2002
    Chattanooga, TN

    Unanswered: Sybase and SAN

    has anyone implemented Sybase on a SAN? if so, how did it go? what steps did you take to migrate? important question: is placement of INDEX and DATA as important on SAN? I've heard with the randomness of placement of the data that separating index and data is not important on a SAN -- true? or false?

    btw -- ASE 12.0 on NT ==> to EMC Symmetrix 8530....


  2. #2
    Join Date
    Sep 2002
    Sydney, Australia
    After experiencing several SANs in production, including two large EMC, I recommend the following:
    - get as much memory in the SAN as you can
    - use RAID 0/1, do not bother with anything more
    - allocate large blocks with a stripesize of 16
    - treat your SAN as a bunch of [pseudo] spindles (ie. logical units)
    - allocate the fewest, largest Sybase devices (disk init) on them
    - even though the effect is lost a little in a SAN, DO separate INDEX, DATA and LOG

    With a SAN, your access speed will be flat across a variety of access types, but your parallelism will suffer. In general, you will not be able to use many of the performance-enhancing features of Sybase.
    Last edited by DerekA; 09-22-02 at 22:22.
    Derek Asirvadem
    Senior Sybase DBA/Information Architect derekATsoftwaregemsDOTcomDOTau
    Anything worth doing is worth doing Right The First Time
    Spend your money on standards-compliant development or spend 10 times more fixing it

Posting Permissions

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