Worth Teaming NICs?

We have a Windows 2003 R2 Server running SQL Server 2005 which is the back-end to our main application, which is used by around 100-150 people at a time throughout the day.  As I'm in IT I don't personally use the application but I'm told that it runs slowly, especially at peak times.

The server hosting the database has two identical Broadcom NICs, but only one is enabled.  I wondered whether I would notice any benefits in terms of speed and performance of the application using the database by enabling the second NIC and teaming them, so that they have the same IP address.

Some of the things I've read online suggest that there would be no discernible benefit other than resiliency.  I wondered what your expert opinions were.
Phil StratfordAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Let's answer this two ways.

1)  Yes, teaming the NIC is worth doing.  Primarily because this will give you additional reduncance even if it does not help your speed problem.

2)  With 100-150 users on SQL Server, the slowness problem should *not* be a bandwidth issue.  I seriously doubt that teaming the NIC will produce any speed boost.

So, I suppose the above is really just confirming what you have already read.

The real solution to your problem is probably going to be more at the DBA level (assuming you have verified that the Windows side of the server is running fine).  Checking the setting and configuration of the server itself, checking indexes, checking query traffic between the app and the database, etc.  There are a whole lot of things that will adversely affect database speed, and yes some of them are on the network end of the equation.  But most of them are not.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
oops!  redundancy ;-)
There is a multitude of apps you can get that will show you your network load, task manager is a good start.
I would use task manager in conjuction with process explorer to see what is really slowing down the process. As stated above, it could be SQL, Proc, Mem, Disk or Network.
Teaming the broadcoms should absolutly be done for failover protection at the least
andyalderSaggar maker's framemakerCommented:
If you set up teaming make sure you do it right, if not you can easily end up with intermittent network connections.

As to performance it's almost always the disk configuration that needs money spent on it at the hardware level. Performance monitor may show disks to be the bottlenkneck when lack of RAM is the real issue though or as already mentioned the SQL setup itself. Ask the users if it is slow for queries or updates or both.
Phil StratfordAuthor Commented:
Thanks for all the tips, I'll team the NICs for resiliency and look at the server itself to work out performance issues.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Networking Hardware-Other

From novice to tech pro — start learning today.