Reserve Instance for SQL

Question

HI..

Are reserve instance for SQL based on every SQL Server or every SQL database?
How we can know if my Database or my SQL server using reserve instance or not?

Answer 1

Hi @Handian Sudianto

I don't want to be mean, but you already asked a similar question about Reserved xyz... and there you got an answer => Azure Portal - Reservations.
If your Azure SQL is not listed there, it is deployed as a PAYG-services.

https://learn.microsoft.com/en-us/answers/questions/1115802/pay-as-you-go-vs-reserve-capacity.html

Whether it is for your SQL Server or just a database depends on the service and how you deployed your SQL...

If it is an Azure SQL database... it is just the database
If it is an Azure SQL Managed Instance... it is for the whole MI, including all databases

I hope my answer is helpful to you,

Your
Bjoern Peters

If the reply was helpful, please upvote and/or accept it as an answer, as this helps others in the community with similar questions. Thanks!