Choosing physical archi for a new SQL 2005 implementation

Giganews Newsgroups
Subject: Choosing physical archi for a new SQL 2005 implementation
Posted by:  SalamElias (eliassal@online.nospam)
Date: Sun, 13 Aug 2006

Hi, Currently I am confronted with an issue to estimate how should we
organize or what should we buy in order to provide high availability and
efficient response times.
I have 3 different  DBs one which have high read activities, one has high
Read-write activity and the third one is for Biztalk server.
I have basic knowledge of SANs. My question, is there a doc or some
instructions or excel worksheet to analyze and play with.
I am thinking of having a secured SAN (2 groups of disks), 4 nodes, 1 active
for the High read activity, 1 active for the read write, third active for
Biztalk and the fourth noeud will be the passif one which will be the
failover for the 3 nodes.
Is this is a good way to go, if yes how about disk structures regarding
log/data for each different functionality.
Last question Is there any webcast about the subject? Thanks in advance

Replies