how to force sql server to use maximum network bandwidth

خرید بک لینک

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 duratio. also when I connect the client directly to the server by etheet 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 made the client application to run so slow rather 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 160 gb ssd and gigabit NIC

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 233 تاريخ: چهارشنبه 29 ارديبهشت 1395 ساعت: 7:09

صفحه بندی