I have a test environment for my Asp.Net 4.0 web applications. It runs on a Dedicated Windows 2003 Webserver (IIS 6) But it's slow! The machine never has 100% cpu and the same for memory. When I run the application on the production server, it's fast as hell.
I think that it has to do with the horrible bandwith the testserver has. It uses a remote SQL server. How can I check if the remote SQL is the bottleneck? And how can I check if the upload of the machine is the bottleneck?
Thanks in advanced, JP
Edit: The network speed: Average ping from test to database is 33ms. www.Speedtest.net gives testserver: 10mbit down/0.8mbit up. Remote databaseserver: 94mbit down/74mbit up. But 0.8mbit up (testserver) is about 100 kilobyte per second. Should be enough for several simple sql queries? or not?