|Subject:||Choosing physical archi for a new SQL 2005 implementation|
|Posted by:||SalamElias (email@example.com)|
|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