@Easy Drive
Thank you for the question and for using Microsoft Q&A platform.
As per my understanding you are trying to create an Azure SQL database using the reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5.
Here are the steps to create a database that is suitable for your reservation:
- Sign in to the Azure Portal.
- Select Create a resource > Databases > Azure SQL Database.
- In the Basics tab, enter the required information such as subscription, resource group, database name, server name, and server admin login credentials.
- In the configure elastic pool tab, select the performance tier and hardware generation that matches your reservation. For example, if you have a reservation for SQL Database Single/Elastic Pool General Purpose - Compute Gen5, you should select the General Purpose performance tier and Gen5 hardware generation.
- Complete the remaining steps and click on Review+Create.
- Your database will be created.
Verify the Reservation Applied:
After creating the database:
- Navigate to Reservations in the Azure Portal.
- Select your SQL Database reservation.
- Check the Utilization section to verify that the reservation is applied. If not applied, confirm the SKU, region, and configuration match your reservation exactly.
Troubleshooting Common Issues
- Mismatch in SKU or Region:
- Ensure your database's region and compute SKU (e.g., Gen5, General Purpose) match the reservation details.
- Insufficient Capacity:
- If your database exceeds the reserved vCore count, only the reserved capacity will be discounted.
- Reservation Scope:
- Verify the reservation scope (e.g., Shared, Single Subscription, or Resource Group).
- If it's scoped to a single subscription, make sure your database is in the same subscription.
- Elastic Pool Utilization:
- If using an elastic pool, ensure that the pool configuration aligns with the reservation.
https://learn.microsoft.com/en-us/azure/cost-management-billing/reservations/view-reservations
https://learn.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview?view=azuresql
https://learn.microsoft.com/en-us/azure/cost-management-billing/reservations/understand-reservation-charges
Hope this helps. Do let us know if you have any further queries.
If this answers your query, do click Accept Answer
and Yes
for was this answer helpful. And, if you have any further query do let us know.