Azure SQL Hyperscale calulator informations

user8702 0

Hi, I'm evaluating to migrate an on premise MS SQL 2012 Cluster to Azure SQL Hyperscale (mainly for storage size limit) and I'm a bit confused on how estimate it in terms of scaling and number of replicas Giving 6 x 32 vCore and 320GB master and slave nodes for 3 large databases, I'm estimating 3 large Hyperscale databases (with e.g vCore 24) with 1 replica for each database How can I estimate costs in order to achieve scalability and high availability for the estimation? Is scaling included regardless costs and provisoned vCore? Thanks in advance Best regards

GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2024-02-24T03:57:49.52+00:00

Hi, @user8702 Welcome to Microsoft Q&A thanks for posting your question. I Understand that you are evaluating migrating an on-premise MS SQL 2012 Cluster to Azure SQL Hyperscale for storage size limit and confused about how to estimate scaling and the number of replicas.

Azure SQL Hyperscale is a highly scalable service that can scale up to 100 TB of data. It provides high availability with automatic failover,

To answer your question, I would recommend raising a support/work with your cloud solution architects . as there are many hidden requirements to understand more about your use case, please let me know if you need any help in raising a support case.

Here is the link on Hyperscale features and pricing https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql

You can also try checking pricing calculator https://azure.microsoft.com/en-us/pricing/calculator/

Regards

Geetha
user8702 0 Reputation points

2024-02-25T00:12:15.75+00:00

Thanks for reply @GeethaThatipatri-MSFT how can I raise support? I'd like to understand how can I estimate the below SQL Server 2012 Cluster using Hyperscale achieving high availability and scaling as on premise with these configuratons

Giving 6 x 32 vCore and 320GB master and slave nodes for 3 large databases
user8702 0 Reputation points

2024-02-25T00:15:30.6766667+00:00

My concern is related to additional charge in case that provisioned database (e.g vCore 24) need to use more provisioned memory in production, in this case additional nodes will be provisioned without charge or I need to upgrade vCores? How can I estimate it during the assessment phase? Thanks in advance
GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2024-02-26T15:52:38.2333333+00:00

@user8702 As a starting point, you can use out migration tools, but to get a final architecture or a solution, you should work with your cloud solution architects.

Regards

Geetha

1 answer

GeethaThatipatri-MSFT 29,377 Reputation points Microsoft Employee

2024-02-27T14:57:45.16+00:00

@user8702 You can start by assessing the server using Azure DMS (in Azure Data Studio migration extension) and see what your potential Azure SQL targets are. It will allow you to do some workload data collection, analysis and optimization based on that as well. As I said, eventually some professional needs to understand the hardware, availability/DR (including long term archival of backups), read-scale, and other requirements to factor in the parameters which may impact the cost.

Regards

Geetha
Please sign in to rate this answer.
Oury Ba-MSFT 18,616 Reputation points Microsoft Employee

2024-03-01T18:19:29.1766667+00:00

@user8702 Please don't forget to mark as accept answer if the reply from @GeethaThatipatri-MSFT was helpful.

Regards,

Oury
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure SQL Hyperscale calulator informations

1 answer

Your answer