How to increase the Azure SQL Database size

Rajendra Goud-Mala 51 Reputation points
2022-12-06T04:38:12.173+00:00

Hello,

I am looking to increase the storage/size up to 10 TB from 4 TB of Azure SQL Database from Azure Portal.
DB size is increasing on daily basis. Azure sql database is configured in Premium P15: 4000 DTUs Pricing tier.

And I am not able to select Hyperscale (On-demand scalable storage) service tier from service tier drop down list.

How can I increase the size of DB. Please suggest. Appreciate your help.

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2022-12-06T05:00:56.487+00:00

    You can upgrade to Hyperscale using this step-by-step tutorial, With Hperscale your database can grow up to 100 TB and will grow automatically without any human intervention.

    Another option you have is to upgrade to Azure SQL Managed Instance General Purpose where your database can grow up to 16 TB as explained here.

    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.