We have recently setup a virtual network that consists of one virtual machine (A3) running MSSQL, and one cloud service (Medium) running a web role.
Our web role will connect to the database using the internal network IP which works fine.
The issue were having is when we try load testing the app the network traffic being sent to the database is high and will fluctuate between 6-9 Mbps but will never go any higher. We are running Wireshark so can monitor when the requests that come into the web role which have no latency but the database requests are taking to long to send over the network.
If we run two instances of the web role we can send roughly double the network traffic to the database vm with out any issues.
Our app is using Entity Framework and our target is to process 25 requests per second with about 10 database calls per request.
Q1: Is there a max bandwidth rate between web roles and a vm using TCP on Azure?
Q2: How can we increase throughput between the cloud service and the database?