You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of…

The correct answer is C. 8. If the number of logical processors is greater than eight (8), use eight data files. If contention continues, increase the number of data files by multiples of four (4) up to the number of logical processors until the contention is reduced to acceptable levels. Alternatively…

Submitted by fernanda_arg· Mar 6, 2026Monitor, configure, and optimize database resources

Question

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You scale up the virtual machine to 16 vCPUSs and 64 GB of memory. You need to provide the lowest latency for tempdb. What is the total number of data files that tempdb should contain?

Options

How the community answered

(18 responses)

A
17% (3)
B
6% (1)
C
72% (13)
D
6% (1)

Explanation

If the number of logical processors is greater than eight (8), use eight data files. If contention continues, increase the number of data files by multiples of four (4) up to the number of logical processors until the contention is reduced to acceptable levels. Alternatively, make changes to the workload or code. https://docs.microsoft.com/en-US/troubleshoot/sql/performance/recommendations-reduce- allocation-contention

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice