15. srpna 2012 19:01
I will explain my problem briefly.
Let us assume that my SQL server box is A and I am using SQL server 2012,desktop and connected to Ethernet. Queries run fast on this.
I am the admin to another server instance which is B. So I used to connect to server B on my machine and writes the queries. Previously it was good and returns 11lakh records in 5secs. But now I got a problem that it takes 10min time to run that.
When I used to connect to B using remote desktop connection from my box and wrote queries on SSMS and it works fine there. I thought that its a network problem so I gave that server B access to some one in my office and tried on their laptops through Wi-Fi and again same problem.
Yesterday night in my home I checked it and its works fine(that's our local Wi-Fi ).
I am getting Async Network IO wait type. I checked the NIC settings and its 100MBPS full duplex.
Anyone could please drive me to the exact solution. I appreciated your solutions.
15. srpna 2012 21:30PřispěvatelCross post: http://social.msdn.microsoft.com/Forums/en-US/sqlkjappmsmgmt/thread/5024e121-4fec-4905-8afd-ff88cca0f3fe