DP-300: Administering Microsoft Azure SQL Solutions

By Microsoft · Question Mode

QuestionQ18

Monitor, configure, and optimize database resources

You have SQL Server 2019 on an Azure virtual machine running Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory.

You scale up the virtual machine to 16 vCPUs and 64 GB of memory.

You need to deliver the lowest latency for tempdb.

What total number of data files should tempdb contain?

Explanation

For SQL Server instances with more than eight logical processors, the recommended starting configuration is eight equally sized tempdb data files. Additional files are considered only when tempdb allocation contention remains, and are added in multiples of four.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!