Azure SQL database: How additional storage (beyond 250GB) being charged?

• praveen_vejandla

  SSCrazy

  Points: 2069

  More actions

  August 28, 2023 at 2:11 pm

  #4273778

  Hi All,

  I have a question on how additional storage (beyond 250GB) will be charged for Azure SQL databases. Is it charged based on Max storage limit (MAXSIZE) or is it based on Allocated space?

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736468

  More actions

  August 28, 2023 at 9:26 pm

  #4274063

  Listed here: https://azure.microsoft.com/en-us/pricing/details/azure-sql-database/single/#pricing

   

  Charged in 1GB increments

• praveen_vejandla

  SSCrazy

  Points: 2069

  More actions

  August 29, 2023 at 10:52 am

  #4274646

  Thanks for the reply. Is this applicable for DTU-based purchasing model as well?

  Suppose, if I shrink a database, in order to reduce storage costs, do I need to lower MAXSIZE as well or not needed?

  Thanks.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736468

  More actions

  August 29, 2023 at 2:59 pm

  #4274857

  Storage is separate from CPU/DTU cost.

  I don't believe MAXSIZE impacts charging. You pay for the GB used.