How to create DB for Reservation

Easy Drive 0 Reputation points
2024-11-20T18:06:39.1+00:00

I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5
Could you please share with me instructions on how to create DB suitable for my reservation

As I understand if I create DB correctly it will link to the reservation automatically, what doesn't happened for me, so maybe I create it incorrectly

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,060 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. NIKHILA NETHIKUNTA 3,505 Reputation points Microsoft Vendor
    2024-11-20T19:01:31.91+00:00

    @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:

    1. Sign in to the Azure Portal.
    2. Select Create a resource > Databases > Azure SQL Database.

    User's image

    1. In the Basics tab, enter the required information such as subscription, resource group, database name, server name, and server admin login credentials.

    User's image

    1. 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.

    User's image

    1. Complete the remaining steps and click on Review+Create.
    2. Your database will be created.

    Verify the Reservation Applied:

    After creating the database:

    1. Navigate to Reservations in the Azure Portal.
    2. Select your SQL Database reservation.
    3. 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

    1. Mismatch in SKU or Region:
      • Ensure your database's region and compute SKU (e.g., Gen5, General Purpose) match the reservation details.
    2. Insufficient Capacity:
      • If your database exceeds the reserved vCore count, only the reserved capacity will be discounted.
    3. 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.
    4. 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.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.