This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi..
Is different between sql reserve instace and reserve capacity? How we can know which model of our exsiting sql server?
Also its true if we buy use reserve instance example for 3 yerars, we pay upfront for 3 years and no monthly bill?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi @Handian Sudianto ,
Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Correct.
That is what the documentation says, and my experience confirms it.
Sorry, I tried to find a customer whom I have access and might take a screenshot that contains both VMs and DBs... but unfortunately, I don't have access to those customers' portals.
I can only show you a filled list with VMs.
Very thanks for your screenshot. Last question, can we make sure for SQL by see something in SQL server properties maybe?
Like on your statement for Azure VM we can see in 'capacity reservation group' on azure VM properties.
No, unfortunately not.
Yes and no, there is no real difference in reserved instances compared to reserved capacity. The main difference is in the naming; both means you buy upfront computing power for your data...
reserved instance = a virtual machine (with SQL Server)
reserved capacity = a SQL database/MI (as a service)
According to Microsoft documentation you can choose between yearly and monthly payments:
You can pay for a reservation up front or monthly. The total cost of up-front and monthly reservations is the same and you don't pay any extra fees when you choose to pay monthly. Monthly payment is available for Azure reservations, not third-party products.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 41%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Thanks for your infformation. So for sql server there are 2 kind of model, reserve capacity and pay as you go, am i correct?
How we can know what model used for my existing sql server? Are this reserved capacity should be shown on reserved dashboard to identify are we using reserve capacity and not use pay as you go?
Sign in to the Azure portal.
Select All Services > Reservations to list reservations that you have access to.
And you should be able to see it directly on the VM in the portal... there is a point "Capacity reservation group"
That for Azure VM, how about Azure SQL Server? how we can make sure it?
Sign in to the Azure portal.
Select All Services > Reservations to list reservations that you have access to.
the dashboard is empty, so this mean my azure VM and SQL server use pay as you go model?
