Share via

migrate sql to Virtual

Biltz 136 Reputation points
2021-08-23T05:18:16.76+00:00

Hello,

We are running SQL Server 2019 Production systems of DB sizes ranging from 3TB to 16TB and still growing on Physical hosts. These system serve very intensive/high load applications like BW,ERP..

There is a planning to migrate these systems from physical to Virtual (VMWare).. need to know if there are any restrictions or recommendation in running such huge system on Virtual.

Please help.

SQL Server Migration Assistant
SQL Server Migration Assistant

A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2021-08-23T08:43:14.127+00:00

    Hi @Biltz ,

    Migrate an existing environment, collect a performance baseline to determine your SQL Server on Azure VM requirements.

    Suggest you reading below MS document , it provides a quick checklist as a series of best practices and guidelines to optimize performance of your SQL Server on Azure Virtual Machines (VMs). It will help you a lot for the migration. Such as that It has a checklist of best practices for SQL Server configuration settings when running your SQL Server instances in an Azure virtual machine in production.

    Checklist: Best practices for SQL Server on Azure VMs

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.

    Was this answer helpful?

    0 comments

Your answer

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