SAN EVA layout for OLTP/OLAP Best Practice -
05-04-2005
, 07:51 AM
Hi,
Is there any white paper or best practice for laying out a SAN running
SQLServer.
My client has a new clustered HP EVA SAN and we are looking at
installing SQLServer on the cluster and laying the file groups out on
the SAN.
One cluster is for production (highly transactional) and the other
cluster runs the reporting databases (read only - pretty much).
Will the same SAN configuration and SQLServer layout be appropriate for
both clusters. What are the pointers here, gotchas?
Each cluster has 2 CPUs and an available 72GB mirrored disk split into
2 volumes. There are 68 x 146GB x 15,000rpm disks in the SAN array.
VRAID5 is being suggested throughout for production and reporting. Both
clusters are attached to the same SAN. Part of the SAN will also act as
a file server.
What other options or considerations exist?
Regards
Liam Caffrey |