question

CherkasovDmitriy-9587 avatar image
0 Votes"
CherkasovDmitriy-9587 asked KalyanChanumolu-MSFT commented

Which azure service should I use.

So I have a pretty big on-premise ssms database and I want to use some data from it in azure Machine Learning.
I need to use just a small amount of data from my db, from certain tables.
Also this data updates from time to time.
I want you to help me with the choice of correct azure service for my purpose.

azure-sql-databaseazure-machine-learningazure-database-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KalyanChanumolu-MSFT avatar image
0 Votes"
KalyanChanumolu-MSFT answered KalyanChanumolu-MSFT commented

@CherkasovDmitriy-9587 Welcome to Microsoft Q&A forums.

From the description of your use case, I understand that the database won't be used round the clock but in short bursts of time, when you want to your ML workloads or while updating the tables from your on-premises database.

You might want to consider Azure SQL Serverless database.
You will be billed only for the time the database is in use and it automatically pauses itself during inactive periods.

Please let us know if you have any further questions.


If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I got it, correct me if I am wrong: I need to create "SQL databases" from azure services and then I will be able to set compute tier of it.
But what if some data will be needed round the clock and some in short burst?

0 Votes 0 ·

Yes, Serverless is available as a compute tier while provisioning an Azure SQL database.
If the database is paused, it will auto resume when it receives a request.
More details on that topic are here


If an answer is helpful, please click on 130616-image.png or upvote 130671-image.png which might help other community members reading this thread.


0 Votes 0 ·