Performance with MS SQL in Azure Virtual Machine

Question

I installed SQL Server in Azure Virtual Machine. Open port 1433, create rule in the firewall.

After that, I created Web-role and connect to SQL Server via Azure Connect.

All works. But performance is very bad: ping 500-900 ms between Virtual Machine and Web-role, simple stored procedures worked 5-7 seconds.

How increase performance?
Will performance increase if I will use virtual network?

SOLUTION

I created virtual netwotk and result is the BEST!

Did you create both the VM and the WebRole in the same data center? Also, you shouldn't be using Azure Connect. It's a deprecated VPN solution. — Jaxidian, Apr 17 '13 at 15:33
Yes, in the one center (West Europe). I will try create virtual network. Thank you! — GePard, Apr 18 '13 at 07:57

score 2 · Accepted Answer · answered Apr 17 '13 at 14:30

2

A virtual network should certainly improve performance because you will cut out the latency between the two cloud services (your VM and your Web Role). This will also be more secure.

answered Apr 17 '13 at 14:30

Rick Rainey

11,096
4
30
48

Rick, but Azure Connect also create VPN. – GePard Apr 18 '13 at 07:33
Yes. I created virtual network and result is the BEST! Thank you! – GePard Apr 18 '13 at 12:39

QFDev · Answer 2 · 2013-04-18T09:31:03.660

One simple test you can do is execute a query while in SQL Server Management Studio on the VM. Then execute the same query from the web server and measure the differences. This way you can see if it's an inefficient query plan or a latency problem.

Latency will always be a much bigger consideration in Azure as your hardware is spread out over a large data center. If you're application is very chatty with the database the latency problem starts to compound. It is therefore good practice to batch up queries, reducing the number of distinct calls to the DB and spool data in asynchronously if you can. This will speed up your application and deliver a smoother user experience.

Don't worry if network latency is causing the poor performance, there's much you can do. The following guide will give you a good overview on Azure Performance best practices to get you started:

http://www.windowsazure.com/en-us/develop/net/best-practices/performance/

Performance with MS SQL in Azure Virtual Machine

2 Answers2