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 8 vCPUs 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 jaden.t· 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 8 vCPUs and 64 GB of memory. You need to reduce tempdb contention without negatively affecting server performance. What is the number of secondary data files that you should configure for tempdb?

Options

How the community answered

(39 responses)

A
15% (6)
B
8% (3)
C
74% (29)
D
3% (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

Topics

#tempdb#data files#CPU scaling#contention

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice