Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a dedicated server setup that has just started causing us issues. Our immediate problem, is that last week, could log into an admin page of one of our websites just fine, now we can't.

It does do a heavy SQL procedure on the SQL database, but as its only a small usage site, im ok with that.

The problem the website is timing out, and the admin's can not log in.

It seems that when the log-in is taking place, the SQL machine and Local server are communicating ok, but the network is being severely restricted. It appears to be being capped at 1.2Mbps.

Transfer speed graph

Its not the SQL query, this runs and completes in 5 seconds. The script timeout on IIS is set to 120 seconds (i dont really want to extend this) SQL machine is a physical box, the webserver is a Virtual machine It looks like we SHOULD be getting 100 Mbps over the local network

Any ideas ?

Edit 1 : Here is a pic showing the local network between the two local machines capped at 200 bytes per second (1 meg) If I can transfer a file at 10 Meg a second, why is SQL server only transmitting its data out at 1 Meg ? http://www.driveiq.com/temp/1meg.png

enter image description here

Edit 2, the INTERNET network connection is 1 MEG, is that just a coincidence that it looks like the SQL server is transmitting over the internet connection as the speed are the same?

share|improve this question
    
Could you perhaps do a file transfer between the servers and see if it happens during that as well? –  Sašo May 15 '12 at 9:40
    
I did a file transfer, and that indeed went @ 10 MB –  Keeno May 15 '12 at 10:56
    
What does the SQL connection string look like? Since a file transfer between the servers is normal, is it possible that the SQL connection string is causing the SQL connection to take a different, less optimal path from the web server to the SQL server? –  joeqwerty May 15 '12 at 11:39
    
Hi, the SQL connection string is using the local machine name for the SQL server. "Server=SQLMachineName;Database=DatabaseName;User ID=xxx;Password=xxx" –  Keeno May 15 '12 at 11:51

1 Answer 1

up vote 1 down vote accepted

In comparing my settings between the two SQL servers, I spotted that accounts used to operate the services where different, changing them requested a server service restart, and this fixed the issue.

oh well.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.