CODEWITHSUNDEEP
azure-sql-databaseazure-web-app-service
Snehal Kalbhor
Snehal Kalbhor

Reputation: 11

Azure database performance is very bad

I am facing performance issues with database hosted in azure, if I run same query in my server response time is 4sec but in azure database it takes around 12secs and sometimes timeout.Basically it takes 3X times the response of server hosted in my company environment. We were using Shared plan after that we tried upgrading the plan to S01 Standard and then to Default1 (Basic: 1 Large), but upgrading plan dint make any difference in performance.Can you please help to make the performance faster.

Thanks.

Upvotes: 0

Views: 676

Answers (1)

guyhay_MSFT
guyhay_MSFT

Reputation: 621

Azure SQL Database charges on performance. So if you want more performance, you should change to a higher priced performance tier.

What performance level are you currently in?

Also a comparison with your desktop/laptop is an apples to oranges comparison. A typical laptop has 4 or 6 cores, 4GB or 8GB of memory and more. Only a larger Premium performance-level could compare to that potential laptop performance. Lastly your laptop doesn't have any HA available, and SQL DB has a 99.99 SLA.

I hope this helps.

Upvotes: 2

Related Questions