Friday, March 9, 2012

Dual Nics problems with SQL 2000 Cluster

HI,
I have two Dell Servers(For high avaiablity each machines have three intel gigabit Networkcards,one for heatbeat,two for clients link) with a disk array.I have installed Windows2003 and setup the Cluster,it's worked well,then i installed sql server 2000 E
E on them through many articles(I created tow sql ip address because i have two nics on each servers).When one node fail,the resource can shift to another node,the sql service is still available.Ok,but when one switch of the two seperate network is down,t
he sql service is nolonger avaliable,there is no use for another network cards on each node? Is there any articles for sql server's installation for nodes with three nics?
Another problem is that it take about 3 min for sql resource such as sql ip address,sql network name,sql server etc to transmit from one node to another,obviously it's too long,but i can't solve it.
I hope I 1can describe the phenomenas and i need your help,thank you!
You could use NIC Teaming on the 2 common NICs. The two teamed NICs combine to present a third "NIC" to the o/s with a common IP Address. SQL Server sees this common IP and doesn't complain when either of the physical NICs or switches fails. As your NI
C vendor if they support teaming (you'll need some Teaming software).
|||If I set two networks,one is 172.20.1.*and the other is 172.20.2.*,then which network should I config for the third "NIC" for all clients(they all have two NICs) to link?
|||When 2 NICs are teamed, only one is in use at any one time. You don't set the IP Address of each NIC you set the single IP address of the resulting teamed "NIC". So, you could have say NIC1 and NIC2 as your physical NICs. Then team them and call the re
sult "Public Network Connection" (or something more useful) which would have the IP address "172...". When you set up clustering, the public network will be "Public Network Connection" rather than NIC1 or NIC2. Make sure you set "Public Network Connect
ion" as the highest priority in the network advanced=>advanced settings list.

No comments:

Post a Comment