Question

You are deploying a mission-critical SQL Server 2022 workload on an Azure virtual machine. The application is write-intensive with frequent, large transactions, and you observe high write latency during peak load. You must configure the VM storage to maximize performance for the transaction log and tempdb while following Microsoft's recommended practices for SQL Server on Azure VMs. Which storage configuration should you implement?

Accepted Answer

Place data files on Premium SSD with read-only caching, place the transaction log on a separate Premium SSD or Ultra Disk with caching disabled (None), and place tempdb on the local ephemeral (temporary) disk.

Answer

Place data files, transaction log, and tempdb all on a single large Premium SSD managed disk to simplify management.

Answer

Place the transaction log on a dedicated Premium SSD (or Ultra Disk) with read/write caching enabled, and place tempdb on the same disk as the data files.

Answer

Place all files on the local ephemeral (temporary) disk to achieve the lowest possible latency for every file type.