Database server in Azure

Asked

Viewed 134 times

1

I created a database server in Azure in the US. Before, my database was in Locaweb. In Azure, the queries to the bank became slower. I tried to create a server here in Brazil, It appears the creation option, but when clicking create show an error message , saying it is not available. Can the distance from the bank server significantly impact my application ? How to free the creation of an Azure database server here in Brazil ?

.net asp.net windows-azure

2 answers

1

Correct when you have access to the SQL machine is to run the DTU calculator so you can estimate the size of the SQL to be hired.

OBS: imagining that it is SQL on Azure service.

DTU calculator http://dtucalculator.azurewebsites.net/

Of course, in Ocaweb you will not be able to estimate the DTU.

I recommend using SQL Pool Elastic on Azure, so every 80% load it replicates a new server horizontally (horizontally pq will equal config from your first server)

And Case still precise you can scale it vertically (changing the config of the machine)

Vertical Scaling sql service is paused, horizontal no.

Recalling that the cost of Azure tends to be higher than Localweb, but has thousands more resources. https://azure.microsoft.com/pt-br/pricing/calculator/

1


Say that distance does not impact performance would be wrong. But how much it impacts?

A default server response time on Locaweb is usually 30ms against 140ms of Azure.

If your query is taking 3 seconds, 110 milliseconds does not represent any significant difference.

I believe it may be the weak SQL standard you took on Azure, there are several 'packages' each with different performance and different prices.

The advantage of Azure is that it has a number of pre-configured performance monitors, which can help you identify bottlenecks.

Besides being a real cloud.

  • Thanks for the reply Dorathoto , My default is the Standard OS. Do you consider it good ? I was able to create the server here in Brazil, just deselect the update V12 at the time of creation.

  • I’m not really good at talking about Azure. I think it is reasonable, nothing spectacular performance, although Ocaweb I always found terrible.. rs

Browser other questions tagged .net asp.net windows-azure

You are not signed in. Login or sign up in order to post.