When a site is already in use with a small number of +5 users, and I make a VIP exchange, I always get SQL errors, for example:
System.Data.Entity.Core.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
I use SqlAzureExecutionStrategy. In addition, other requests during the VIP exchange seem to take about 30 seconds, which makes the site really not responsive, even though the mid-tier environment is already fully warmed up.
- Is there any way to prevent this?
- Why am I not reading about it? Do others who do not care about a few broken requests and a slow timeframe do 30 seconds, or am I missing something significant in my Sql / EF settings?
source
share