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