question

hafeesjavad-2988 avatar image
0 Votes"
hafeesjavad-2988 asked KyleDrummond-4147 edited

SQL DB in Azure for not frequent(once in a while) usage

What is the best option in Azure to have PaaS Sql db which is rarely used

azure-sql-database
· 1
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.

To follow-up, Please let us know if you have further query on this.
Please don’t forget to Accept the answer

0 Votes 0 ·
learn2skills avatar image
0 Votes"
learn2skills answered

Hi @hafeesjavad-2988


My suggestion you can take SQL DB, purchase model- Single Database DTUs
Single databases are fully isolated databases optimized for workloads when performance demands are somewhat predictable. You can scale a single database up or down through the basic, standard, and premium service tiers to get the performance and features your app needs, precisely when it needs it. Each tier is distinguished primarily by performance, which is measured in Database Transaction Units (DTUs).

Database transaction unit (DTU)-based purchasing model. This purchasing model provides bundled compute and storage packages balanced for common workloads.
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models

Pricing details https://azure.microsoft.com/en-us/pricing/details/sql-database/single/

91645-image.png



If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.




image.png (26.9 KiB)
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.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

My suggestion is to consider using Azure SQL Database Serverless. Serverless is price-performance optimized for single databases with intermittent, unpredictable usage patterns that can afford some delay in compute warm-up after idle usage periods.

The serverless compute tier also automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. This is the only computer tier that is paused allowing you to save money when the database is not in use, for all the other Azure SQL database compute tiers you have to pay for each hour even if the database is not in use.

Please read more about Azure SQL Database Serverless here.


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.

KyleDrummond-4147 avatar image
0 Votes"
KyleDrummond-4147 answered KyleDrummond-4147 edited

My suggestion you can take SQL DB, purchase model- Single Database DTUs
Single databases are fully isolated databases optimized for workloads when performance demands are somewhat predictable. You can scale a single database up or down through the basic, standard, and premium service tiers to get the performance and features your app needs, precisely when it needs it. Each tier is distinguished primarily by performance, which is measured in Database Transaction Units (DTUs).

Database transaction unit (DTU)-based purchasing model. This purchasing model provides bundled compute and storage packages balanced for common workloads.
https://docs.microsoft.com/en-us/loan/azure-sql/database/purchasing-models

Pricing details https://azure.microsoft.com/en-us/pricing/details/sql-database/single/

thanks for the links
is there any Microsoft product that also has Azure in its pricing package included?


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.