Azure Cloud is one of the best places to run your SQL Database and currently Microsoft offers three different instance options.
1)Single 2)Elastic Pool 3)Managed Instancesit is very important to understand which one to choose depending on your workload. Let see some of the used cases…
In single database model each database has its own resources, and it is best suited for the application which have predictable workload performance.
While the elastic pool uses the shared resources for the databases. It is cost-effective option for maintaining multiple databases. pooled resources can offer better performance and value for money and best suited for the database that have varying and unpredictable demands.
Managed instance designed for businesses looking to migrate their database to a fully managed Platform as a Service (PaaS) environment in the cloud. Managed Instances have several features that do not exist in Azure SQL Database(single+elastic) like Cross Database Queries and Transactions, SQL Server Agent, and Database Mail, linked servers, service broker etc…
Comments
Post a Comment