SQL Server Multiple NICs

[ekinike]

I have a SQL 2000 server running on Windows 2000 Server and am looking to improve performance. Would adding a second NIC be a viable solution?

If so, could both NICS have assigned IP's from the same subnet? Can I achive this without using NLB?

If anyone has any suggestion/insight or can point me to some helpful resources, it'd be helpful.

 

[mrdenny]

Yes you can have more than one NIC per machine.

Are you maxing out the current NIC? You probably aren't. I've only sean one SQL Server that could max out it's NIC for more than a few seconds a day.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ekinike]

Do you have any useful links I could reference?

 

[MDXer]

Search around for Multihomed this is the term for what you are wanting to do. I used it once on a prior project and the sole purpose was to get massive amouts of data from Server A to Server outside the network. Our servers were wired together using the Multihomed nics. We were moving something like 250-500GB between the 2 machines.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck