InvalidMaxSizeTierCombination error while performing scaling up operation

Published Dec 22 2021 02:40 AM 830 Views
Microsoft

Worked on a service request where the customer was getting an error InvalidMaxSizeTierCombination while performing the scaling up operation.

 

Basically, the customer was trying to scale up the storage of his Azure SQL database from 500 GB to 1TB in the premium p6 tier.

The customer was reported below error message

Status message:

{

    'status': 'Failed',

    'error': {

        'code': 'InvalidMaxSizeTierCombination',

        'message': 'The tier 'Premium' does not support the database max size '1073741824000'.'

    }

}

 

Here is the things happened.

When I tried using the PowerShell with the same max limit value, I got a similar error.

As per the calculation instead of 1024000*1024*1024=1073741824000, we have to give 1099511627776

 

Example-

1TB

1 * 1024 GB

1 * 1024 * 1024 - MB

1 * 1024 * 1024 * 1024 - KB

1 * 1024 * 1024 * 1024 * 1024 – Bytes

 

  • If we convert this 1073741824000 bytes value to GB’s it will be 1000 GB. We have to provide values on those ranges only. P6 (1 , 2 , 5, 10 , 20 , 30 , 40 , 50 , 100 , 150 , 200 , 250 , 300 , 400 , 500, 750 , 1024) GB
  • We can perform using the portal and PowerShell also using the below command.

 

Set-AzSqlDatabase -ResourceGroupName "<rgname>" -DatabaseName "<dbname>" -ServerName "<servername>" -Edition "premium" -RequestedServiceObjectiveName "P6" -MaxSizeBytes 1099511627776

 

PowerShell snippet for reference

 

rahulrandive_0-1639816646189.png

Happy learning!

 

Co-Authors
Version history
Last update:
‎Dec 21 2021 02:00 AM
Updated by: