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

Maripili gravatar image

394 32 33 35

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

1 answer: sort newest

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

Tim gravatar image

36.4k 38 41 139

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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: 685 times

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