Azure sql database price

Question

Hi friends azure SQL database cost is very high how to reduce please suggest your advice what steps are there If I chose basic it is only 2gb my database is more than 2gb

Answer 1

You have the option of using Azure SQL Serverless that is able to auto-pause after X minutes and you pay per minute instead of per hour.

For other Azure SQL flavors (DTU-model, vCore-model) you scale down the service tier during non-business hours or during the weekend.

With Azure SQL DTU-model you don't have to pay licesing fees.

In addition, you can take advantage of reservation discount for Azure SQL Database.

Answer 2

additional to Albertos' answer:

even with a "normal" Azure SQL database, you can create an automation which "pauses" your databases fees
https://www.sql-aus-hamburg.de/en/pause-resume-backup-an-azure-sql-database-with-powershell-part-3/

The question is, what do you really need and what do you actually have? And what are your requirements?

Answer 3

Just adding a note, make sure you size your Azure SQL database appropriately, along with the Database Migration Assistant; the Azure SQL Database DTU Calculator is an excellent place to start by capturing the performance data:

• https://dtucalculator.azurewebsites.net/