You work for MDFT Pro, a well-known training agency planning to deploy a new Azure virtual machine to host a Microsoft SQL Server instance for their course management system. Mark, the SQL Server Performance Engineer, is responsible for configuring the disk layout to optimize performance and cost. The SQL Server instance will handle student registrations, course enrollments, and real-time assessment processing, requiring careful attention to disk performance. Mark needs to configure disks for different SQL Server components, ensuring that the solution minimizes latency for transaction logs and minimizes the impact on the virtual machine’s overall IO throughput quota. Specifically, he has asked you to recommend the most appropriate disk type for the TempDB workload, which SQL Server uses extensively for temporary data operations and internal sorting.
Which type of disk should you use for the TempDB workload?
Choose the correct answer from the options below.
Explanations for each answer: