dbTalk Databases Forums  

SAN EVA layout for OLTP/OLAP Best Practice

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss SAN EVA layout for OLTP/OLAP Best Practice in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
liam.caffrey@gmail.com
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.