Can Azure SQL DTU Basic storage be increased?

K. Kong 151 Reputation points
2023-10-07T14:56:52.6866667+00:00

I have subscribed to an Azure SQL database Basic plan with 5 DTUs. It says Data max size 2GB. Currently, I am using only 26MB. Although my usage is unlikely to hit 2GB in the foreseeable future, I would like to know what happens if it really hits 2GB? Will Azure SQL just freeze, or will it expand the storage and charge accordingly?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. TP 125.8K Reputation points Volunteer Moderator
    2023-10-07T15:11:34.77+00:00

    Hi,

    Yes, when needed you can switch to Standard S0 SKU which includes 10 DTUs and 250GB. You can do this in the portal by navigating to your database -- Settings -- Compute + storage blade, changing the service tier to Standard and setting max data size.

    azure sql database scale up sku

    Please click Accept Answer if the above was useful.

    Thanks.

    -TP

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

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.