0

I have deployed the web site to Azure Cloud (WEBAPP) and the SQL DB to Virtual Machine that I have created on Azure.

Web App is MVC 5 and using EF6 to connect to SQL DB, Before I migrated it was fast but after the migration the database open connection is very slow.

I did some research on how to create a Azure VNet to move both WebApp and VM under same Virtual Network (VNet), But I couldn't do it . If anybody had this issue and knows any clues or directions that would be great.

I also tried this: Slow Database Connection from Azure Web Application But couldn't resolve my issue.

I assume the solution is to create a VNet and move both under the same VNet, But couldn't find any articles. Please share your thoughts,...

Community
  • 1
  • 1
VoidA313
  • 516
  • 3
  • 10

1 Answers1

2

You are running the database from a virtual machine. Databases need memory and fast storage. You are not telling what kind of server you are using. Upgrade the machine to decent memory and premium storage. Next check if all your resources are on the same azure site (region). If not move the to one region. You say you can't put them in the same vnet, what is the error or reason? If you can solve that the machines will get better connectivity.

Peter
  • 27,590
  • 8
  • 64
  • 84
  • Thanks for the feedback Peter, I think your point is right. I upgraded the VM from 2 cores - 4 cores , (same memory size 14GB). For the VNet I have created two sub-nets for front end and back end , But my issue is how can I link Azure WebApp interface and VM interface under those two sub-nets. Please keep in mind I have linked my external domain to WebApp public IP ( CNAME , A Record) . Thanks – VoidA313 Mar 02 '16 at 23:31