Does the solution meet the goal?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution. Determine whether the solution meets the stated goals.

You deploy the virtual machine (VM) by using the following settings:

The workload on this instance has a very high tempdb load.

You need to maximize the performance of the tempdb database.

Solution: You use an A8 compute-intensive instance and store the tempdb database in Standard storage.

Does the solution meet the goal?
A . Yes
B . No

View Answer

Answer: B

Explanation:

For D-series, Dv2-series, and G-series VMs, the temporary drive on these VMs is SSD-based. If your workload makes heavy use of TempDB (such as temporary objects or complex joins), storing TempDB on the D drive could result in higher TempDB throughput and lower TempDB latency.

References: https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance