SQL Server db OR an Azure SQL (serverless) db?

[blmiles]

Hello,

As per title, I'm replacing my current database(s) and about to configure db in Azure.

Is it better to add a new db to current SQL Server instance OR new db as an Azure SQL (serverless) db?
For my purposes, I don't need MS Entra ID and my users don't use their own credentials to be able to connect to the db from the App.

Any pitfalls in going with an Azure SQL (serverless) db? or advantages?

Thanks

[adrianhall]

I do not test with SQL Server instances except in very rare occurences.

My test suite for live tests are all based in Azure:

• Azure SQL
• Azure Flexible Server for PostgreSQL
• Azure Flexible Server for MySQL
• Cosmos DB (Cosmos SQL)
• Cosmos DB (Mongo DB)

You can see how I configure each one by examining the modules under the infra folder.

When doing live tests, I observe that Azure SQL is the fastest of the set (approximately 4x faster than MySQL and 2x faster than PostgreSQL) when doing the query tests. The comparison is similar for the write tests. Cosmos is the fastest when doing queries (even when I take into account that I can't run 30% of the tests due to Cosmos query limitations) but the slowest when doing writes (on par with MySQL). Note that this is observed via testing and does not necessarily represent what you can expect for real-world speeds.

[blmiles]

Update to this deploy problem...

Downloaded the Deployment Profile from the Azure App Service. Nothing edited. Imported as-is. Exactly what Azure provides ... get this on the output on deploy. I just wish for once, MS did not make things so cryptic... :(

Error : Web deployment task failed. (Could not connect to the remote computer ("[myapp]appservicedev-bcanebahb3cnhshu.scm.canadacentral-01.azurewebsites.net"). On the remote computer, make sure that Web Deploy is installed and that the required process ("Web Management Service") is started. Learn more at: https://go.microsoft.com/fwlink/?LinkId=221672#ERROR_DESTINATION_NOT_REACHABLE.)
The requested resource does not exist, or the requested URL is incorrect.
Error details:
Could not connect to the remote computer ("[myapp]appservicedev-bcanebahb3cnhshu.scm.canadacentral-01.azurewebsites.net"). On the remote computer, make sure that Web Deploy is installed and that the required process ("Web Management Service") is started. Learn more at: https://go.microsoft.com/fwlink/?LinkId=221672#ERROR_DESTINATION_NOT_REACHABLE.
The remote server returned an error: (404) Not Found.

[adrianhall]

This is an App Service + VS deployment issue - can't help as that isn't what I use.

I'd recommend Azure Developer CLI instead. That's what I use throughout all my work; it's also how the sample server is deployed. Since the sample server is deployed that way, you can just use it as a template and swap out the server code for your own server code. if you change the project name, you'll only need to change the azure.yaml file to point to the new location.

[blmiles]

Thanks again Adrian, I'll look at that and give it a try....

[blmiles]

THAT is excellent. Never used AZD CLI and it worked perfectly.
AND my data is sync'ing between multiple devices!

Thanks very much @adrianhall

[adrianhall]

If you want or need to use something “extra” than just a website + a DB, check out “awesome AZD” - https://aka.ms/awesome-azd - there is likely a template already made for you. If not, you’ll need to use bicep (which defines the infrastructure - not hard, but definitely more work.