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.
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