Hello everybody,

Right now we have to know, why the response from the SQL Server are sometimes to slow. We monitored the activity of the server and the RAM and CPU are OK, but we found some lost of packages during the data transfer... So we think now that the cause could be the Network Card (10/100/1000) and all the requests incoming from all the applications interacting whit it. Do you think that there's the posiblity to decrease the response time with another Network Card? (Teaming) How handel it the SQL 2000?

Thanks a lot for your information.



more ▼

asked Apr 27, 2012 at 10:44 PM in Default

avatar image

394 33 33 38

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Is the network interface card saturated? Even though it is 10/100/1000 NIC is it set to auto negotiate and the port in your switch set to auto negotiate? If it is flapping between 10, 100, or 1000 then you have a problem. Depending on the firmware of your switch and the driver of the NIC, you might be better setting the port and the NIC speed to 1000 FULL rather than AUTO. This was more common many years ago but could be your issue. As for teaming the NIC's, if you are not maxing out the Gigabit speed, then adding an additional NIC probably won't help a great deal.

Have you noticed that the performance issue is a specific time of day or very random? Is it for all connections or just a certain connection from a particular application server? The issue could be with the application or client and not with your database server.

Any addition information you can provide will help us help you.

more ▼

answered Apr 28, 2012 at 05:36 PM

avatar image

40.4k 39 84 166

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 27, 2012 at 10:44 PM

Seen: 780 times

Last Updated: Apr 28, 2012 at 05:36 PM

Copyright 2016 Redgate Software. Privacy Policy