I created a Azure database server in the US. Before my database was in Locaweb. At Azure, the bank's queries were slower. I tried to create a server here in Brazil, the creation option appears, but when I click create create an error message saying that it is not available. Can the server's distance from the bank significantly impact my application? How to free the creation of an Azure database server here in Brazil?
Database Server on Azure
1
asked by anonymous 14.04.2016 / 17:23
2 answers
1
To say that distance does not impact perfomance would be wrong. But how much does it impact?
A default response time of a server in locaweb is typically 30ms versus 140ms of Azure .
If your query is taking 3 seconds, 110 milliseconds does not make any significant difference.
I think it may be the weak SQL standard you picked up on Azure, there are several 'packages' each with different performance and different prices.
The advantage of Azure is that it has several preconfigured performance monitors, which can help you identify bottlenecks.
In addition to being a real cloud.
14.04.2016 / 17:54
1
The correct one when you have access to the SQL machine is to run the DTU calculator so that you can estimate the size of the SQL to be contracted.
NOTE: I'm wondering what SQL is about Azure service.
DTU Calculator link
Of course, in locaweb you will not be able to estimate DTUs.
I recommend using SQL Elastic Pool in Azure, so every 80% of the load it replicates a new server horizontally (horizontally it will be the same as the config of its first server)
E If you still need it, you can scale it vertically (changing the configuration of the machine)
Vertical Scaling The sql service is paused, not horizontally.
Remembering that the cost of Azure tends to be higher than Localweb, but it has thousands of extra resources. link
08.12.2016 / 16:34