single select statement Running Slow due to wait times

Question

Hi,

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.

Thanks

Answer 1

Cross post: http://social.msdn.microsoft.com/Forums/en-US/sqlkjappmsmgmt/thread/5024e121-4fec-4905-8afd-ff88cca0f3fe

---

Sean Gallardy, MCC | Blog | Twitter