I want to move to Gen 5 hardware.

Chakri Yadav 0 Reputation points Microsoft Vendor
2023-03-20T19:14:06.69+00:00

I want to move to Gen 5 hardware. But, when I tried to do that, the platform said: The

current pool performance level and per-database performance settings do not allow the number databases selected."

How to resolve this issue?.

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,775 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Sreeju Nair 12,266 Reputation points
    2023-03-20T19:30:56.82+00:00

    It seems you are trying to select the CPU pool that is not enough to server the currently available databases. Can you check the setting "per-database performance settings". Try to remove the setting or reset it.

    Hope this helps

    0 comments No comments

  2. RahulRandive 9,506 Reputation points
    2023-03-20T23:11:57.54+00:00

    Please refer to the blog below for instructions on how to move to Gen 5 hardware.

    It also includes a table with SQL DB Mapping Guidance, which can help you select the appropriate compute size.

    https://techcommunity.microsoft.com/t5/azure-sql-blog/gen4-hardware-deprecation-update-impacting-sql-database-sql/ba-p/3500926

    https://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql

    Thank you!

    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.