QuestionQ6

Monitor, configure, and optimize database resources

You have an Azure subscription.

You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.

You must configure the virtual machine disks to meet these requirements:

  • Minimize latency for transaction logs.
  • Minimize the impact on the virtual machine's IO throughput.

Which disk type should be used for each workload?

Each disk type may be used once, more than once, or not at all.

Drag & Drop
TempDB:
Transaction logs:
Explanation

TempDB can use the VM's local temporary disk because it is recreated after SQL Server restarts, and local storage avoids consuming remote managed-disk throughput. Ultra Disk provides high IOPS, high throughput, and consistently low latency, making it appropriate for transaction-log files.

Learn more

Community Discussion

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