Free Preparation Discussions
MENU
Microsoft DP-300 Exam - Topic 1 Question 128 Discussion
Topic #: 1
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?
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
King
4 days agoTyisha
9 days agoEmogene
14 days agoCharolette
20 days agoAleisha
25 days agoBlossom
30 days agoCarolann
1 month agoWava
1 month agoLaurel
2 months agoShelba
2 months agoSkye
2 months agoLuisa
2 months agoEzekiel
2 months agoLottie
2 months agoAnnelle
4 months agoMerissa
4 months agoSherill
4 months ago