Share via

Can you increase or decrease the size of a PaaS sql after it is created? (i.e. P4 change size to P6 / P6 decrease size to P4)

David Kim 66 Reputation points
2020-08-18T14:36:28.65+00:00

Can you increase the size of a PaaS sql after it is created? (i.e. P4 change size to P6)? Can we downgrade the size from P6 to P4?

Wondering if you downgrade from P11 (4 TB storage) to P4 (500 Gb storage) that if your database might be impacted? Let's assume the database is 300 GB on the P11 before down sizing.

Does this downsizing and upsizing also apply to managed SQL instances?

Does SQL PaaS have any HA ability like SQL AG (two HA nodes locally)?

Azure SQL Database

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mark E 76 Reputation points
    2020-08-18T23:42:24.73+00:00

    You can change the size of the SQL PaaS instance and scale down, however the constraint will be the disk utilisation and if it will fit into the smaller instance configuration. You should also be aware that you will take a hit in performance with a smaller instance plus a small potential for an outage as the instance resizes.

    The approach should work also with managed instances per:
    https://learn.microsoft.com/en-us/azure/azure-sql/database/scale-resources

    The SQL platform on Azure is fairly resilient and you can set some zone redundancy, but not all features are there with managed SQL currently
    https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla

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