Discuss Microsoft DP-300 Exam Topic 1 Question 128

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 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?

D64

Suggested Answer: C

The number of files depends on the number of (logical) processors on the machine. As a general rule, if the number of logical processors is less than or equal to eight, use the same number of data files as logical processors. If the number of logical processors is greater than eight, use eight data files and then if contention continues, increase the number of data files by multiples of 4 until the contention is reduced to acceptable levels or make changes to the workload/code.

https://docs.microsoft.com/en-us/sql/relational-databases/databases/tempdb-database

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

26 comments · newest first

Vincent 3 days ago

I think it should be 8 data files. More vCPUs, better performance.

Vilma 8 days ago

I’d go with 8 too. It’s the best practice.

Emmanuel 14 days ago

8 files will give the lowest latency for sure.

Karina 19 days ago

I feel 4 might be enough, but 8 is safer.

Junita 24 days ago

Definitely 8. It reduces contention.

Jeff 29 days ago

But with 8 vCPUs, 8 files is optimal for tempdb.

Sunshine 1 month ago

I’m leaning towards 4 files. It’s a good balance.

Ronnie 1 month ago

I agree, 8 files make sense for performance.

Janessa 1 month ago

I think it should be 8 files. More vCPUs, more files.

King 2 months ago

I’d go with 8 too. Latency is key!

Tyisha 2 months ago

8 files is the best practice for scaling.

Emogene 2 months ago

I feel 4 is enough. Not always need max files.

Charolette 2 months ago

Definitely 8. It reduces contention.

Aleisha 2 months ago

But with 8 vCPUs, 8 files makes sense for tempdb.

Blossom 3 months ago

I’m leaning towards 4 files. Seems balanced.

Carolann 3 months ago

I agree, 8 files for optimal performance.

Wava 3 months ago

I think it should be 8 files. More vCPUs, more files.

Laurel 3 months ago

Yeah, 8 makes sense, but it seems like a lot!

Shelba 3 months ago

I thought it was 64 files for some reason.

Skye 3 months ago

Wait, isn't 4 enough?

Luisa 4 months ago

Definitely 8 files for optimal performance!

Ezekiel 4 months ago

Tempdb should have one data file per vCPU, so 8 files.

Lottie 4 months ago

I think the best practice is to have multiple data files, but I can't remember if it should be equal to the number of vCPUs or something else.

Annelle 5 months ago

I feel like I should know this, but I can't recall if it's 8 or if there's a cap on how many files we should actually use.

Merissa 6 months ago

I'm not entirely sure, but I think I practiced a question like this where the answer was 4 files for a lower number of vCPUs.

Sherill 6 months ago

I remember reading that tempdb should have one data file per vCPU for optimal performance, so I think it might be 8 files.

Microsoft DP-300 Exam - Topic 1 Question 128 Discussion