Organizations are increasingly migrating their IT ecosystem comprising of applications, data repositories, and services to the cloud from on-premises or private datacenter to reduce capital and operational expenditure on hardware and infrastructure. In the context of SQL Server as the database server, businesses can select from a wide range of options in the Azure SQL service portfolio to modernize and extend their SQL Server applications to the cloud. In this article, let us delve into Azure SQL Database serverless, a compute tier that is billed based on the actual workload per second for single databases and can scale automatically.<\/p>\n
The Azure SQL Database serverless compute tier is ideal for databases with intermittent and unpredictable usage. The service is optimized with a price-performance tradeoff that simplifies performance management for databases using auto-scaling and an auto-pause function to reduce spends. Here are some ideal scenarios for using the Azure SQL Database serverless tier.<\/p>\n
The process of creating a new database or moving an existing one to the serverless compute tier is similar to creating a new database in provisioned compute tier.<\/p>\n
Although the auto-scaling and auto-pausing capabilities in the serverless tier for Azure SQL Database can appear to be a tempting option, there are several reasons why a provisioned tier might be a better fit for most workloads. Not only is the compute responsiveness lower after inactive periods in the case of the serverless tier, but also the cost could be more than it would in provisioned if there is a high load for prolonged periods.<\/p>\n
As a Tier 1 Microsoft CSP,<\/strong> with Gold competency in specializations such as Cloud Platform and Cloud Productivity, Apps4Rent can guide you to the right solution for your specific needs. Contact our Microsoft certified experts, available 24\/7 via phone, chat, and email for our managed Azure services<\/a><\/span>.<\/p>\n