How to minimize the cost for a sql database
I have a website that need a database to store some user information and a blob storage to save some files.
I want to minimize the cost as much as possible so I played around in Microsoft Azure Pricing Calculator with a Azure SQL Database. For the database I think that over it's hole lifetime 2GB of storage would be enought.
I arrived to 2 options that where dirt cheap but I don't really understand what it gives me.
First is with a serverles computer for 3600 seconds (of runtime?)
Is that time the time that my database is processing the request? For example if I have a select statement that takes 1 sec to complete I'll be left with 3599 sec for that month? If that's the case what happens if I run out of time?
Second option is using a Hardware Type: Gen 4
but for this one I don't have any other options to configure my needs. Is this obsolete? Can I rely on it for production?
If you need a very cheap one use the Basic or S0.
Keep in mind that Basic are very slow: try to connect to it through SSMS.
Serverless is for databases that you pause for 3/4 of the day. It might be the case for you but keep in mind that when you use them they will cost a lot. I don't think this will be suitable for you.
- Azure SQL database backup?
- Azure .NET SDK: Scale Azure SQL databases through SDK
- EF6.5 SetExecutionStrategy vs SetTransactionHandler
- Creating External table in Azure SQL Database using ADLS2 Datasource
- Search a column in database
- How to reduce the no. of columns on join when accessing a navigation property?
- sqlcmd fails with Incorrect syntax near ';' after upgrading to .NET 8
- ODBC Driver 18 Not Found in Azure Function Using Python 3.11
- SQL Post Deployment SQL CMD Variables and YAML Task
- 'dbo' user should not be used for normal service operation
- Logic App to call Azure SQL stored procedure passing datetime param
- How do I stop and start a SQL Azure database?
- How to react to message from Microsoft regarding updating API's
- Powershell - Connecting to SQL Server using Connect-AzAccount (With MFA)
- Why can't I use a Terraform `move` block to move an Azure SQL Database to a different resource name?
- Need help in understanding Select Within Select with Where
- Selecting last instance of a column, but comparing different column with CASE
- Is it safe to rely on SqlConnection retry logic while using SqlCommand?
- Clustered column store not aligning GUIDs to segments despite ordering
- How do you check the status of a SQL Import Export Operation in Azure?
- Unable to create stored procedure through Azure pipeline
- Can we recover a database from a deleted server in Azure SQL
- How to insert CSV file from Azure Repo to Azure SQL Database via Release Pipeline?
- How to connect to Azure pass DB from a secure network
- Perform an update to a value and use that value to update another value during the same update process
- Reach Azure SQL database with dynamic IP addresses
- Trying to connect to SQL DB - provider: TCP Provider, error: 26 - Error Locating Server/Instance Specified
- I want to fetch Azure SQL table data from ADF to use as input in copy activity
- The SELECT permission was denied on the object 'Users', database 'XXX', schema 'dbo'
- Azure SQL analysts can create views from forbidden cross database data