SQL connection is too slow
- by user66905
We have a business web application in ASP.NET + SQL Server 2008.
In the beginning, SQL Server and IIS were on the same machine. Now we bought another machine. Current configuration is IIS machine plus SQL Server machine, and they are connected by a 1gb LAN connection.
With this configuration our web application is slower than before. Max bandwidth is 1-2% of network, about 15mbps.
When we use another threads to the same SQL Server from the same IIS machine, network use is higher. So this is no problem with SQL Server.
Ho we can make higher bandwidth for this SQL connection?
Specs:
.Net 3.5
SQL Server 2008 Standard
file transfer can use 100% of LAN SQL
connection by TCP/IP protocol SQL
logins Pool tested with enable and