Possible approaches from Azure to meet a requirement of 4.5 GBps throughput

Gollu Venkata Shyam Swaroop 11 Reputation points
2020-07-31T20:32:49.26+00:00

we have a customer.. who have a physical box at his on-prem with SQL running on it... that delivers throughput of 4.4. GBps . Now they are looking for a solution from Azure that can meet the throughput, when they migrate over..

could you pls help with possible outcomes / approaches that can be recommended to achieve the desired outcome..

SQL Server on Azure Virtual Machines
{count} votes

1 answer

Sort by: Most helpful
  1. vipullag-MSFT 26,487 Reputation points Moderator
    2020-08-06T11:40:51.517+00:00

    @Gollu Venkata Shyam Swaroop

    Apologies in delayed response.

    Once the workload is migrated to Azure, for getting throughput in Gigs, this can be achieved by Express Route. If the data has to be moving from on-prem to Azure depending on your use-cases.

    Please check the NW through puts documentation for more details here.

    If the SQL is migrated to azure VM as IaaS, then please ensure you select recommended VM Type and disk type for IOPS and Throughput.

    If you are planning to use Azure SQL Managed Instances read more info here.

    Please check these links for SQL Server best practices and performance guidance:

    https://learn.microsoft.com/en-us/azure-stack/user/azure-stack-sql-server-vm-considerations?view=azs-2002

    https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices

    Also, please check the SQL Migration Features comparison here.

    Please 'Accept as answer' if it helped, so that it can help others in the community looking for help on similar topics.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.