The proposed MS SQL 2008 DB will be about 800MB in size.
The ESX server is expected to host 5 VMs (all Windows 2008) in it.
I've seen DB servers with 4 FC ports & some with 2 FC ports
On what basis/criteria do we decide how many FC / fibre ports
to connect each DB & ESX host?
The SAN switch port is going to be of 4Gbps or 8Gbps (I don't
know at this moment)
If 2 FC ports are connected (to two different fabric switches
for redundancy), are they active-passive (live-standby)
or active-active? For this question, I'm trying to establish
the total nett throughput (if it's active-active, then it's double
If multi-pathing is used for ESX, it it better to have 2 or 4
FC ports connected?
If we're going to take full backup of the 800MB database
daily, would it help to have 4 FC ports connected to the
DB assuming I have 4x 1Gbps NIC ports connected?
Is there such thing as setting up a separate pair of FC switches
dedicated for Backup LAN? If this is so, then I guess 2 FC ports
of the ESX/DB server go to the FC switches (designated for
backup) & another 2 FC ports to another pair of FC switches
for storage? Or rather most people just zone their FC switches
such that tape libraries have one zone while the storages have
separate zones? Assume the DB & ESX hosts are not functioning
as media backup servers.