QuestionQ160

Migrate SAP workloads to Azure

You have an on-premises SAP NetWeaver deployment. It has a DB2 data store containing a 5-TB SAP database.

You plan to migrate the deployment to SQL Server on an Azure virtual machine.

You need to optimize transaction-log write performance during the migration. The solution must not affect the virtual machine's I/O quota.

What should you do?

  • A Place the transaction logs on the temporary disk.
  • B Place the transaction logs on a striped volume of Premium SSD disks.
  • C Place the transaction logs on an Ultra disk.
  • D Enable the write cache for the disk that hosts the transaction logs.
Explanation

Ultra Disk is intended for I/O-intensive, latency-sensitive workloads such as transaction-heavy databases. An Ultra Disk-compatible VM allocates dedicated bandwidth between the compute instance and the block-storage scale unit, supporting high-performance transaction-log writes without relying on the VM’s regular disk I/O quota.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!