I have a program written in Delphi that uses SQL Server 2008 as database engine. I am on a p2p link provided by two nano station m5. When I run a specific query inside of the program, the network monitor shows that the client is grabbing some data from server with 8Mb/second for 6 seconds duration.
Also when I connect the client directly to the server by ethernet cable and run the same query it grabs the same data but faster (Getting those data with 20mb/second just for 2 seconds duration)but when I copy a large file from server to the client , it will be copied with up to 55Mb/second.
It is bothering me because it causes the client application to run so slow than real network bandwidth is capable to, I want to know if there is a way to force sql server use maximum network bandwidth ?
Windows Server 2012 R2 and SQL Server 2008 running just with tcp/ip network protocol enabled and 100MB full duplex network server core i5 with 8GB DDR 3 and 160GB SSD and gigabit NIC