Linked Server; only 10-15% of Network bandwidth

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Linked Server; only 10-15% of Network bandwidth

Author

Topic

mrpellepelle
Starting Member

3 Posts

Posted - 2012-03-13 : 11:32:05

Hi guys,

I'am building up two new SQL Servers 2008 R2.
2x Quad Core CPU with 3xRaid10, 288GB RAM , 1gbit NIC and so on. There should be enough power to provide and recieve data.

I created a linked server between the servers and tested the datatransfer with a simple "Select * Into ..." from a 3GB table.

I am wondering why the Network bandwith of 1 gbit is only used by 10/15 %.

Using 3 parallel Querys will result in about 40% bandwith usage.
I would expect SQL Server to limit the bandwith.

What is the reason for this limitation? Is it adjustable?

Greets
Daniel

mrpellepelle
Starting Member

3 Posts

Posted - 2012-03-15 : 05:01:24

nobody?