QuestionQ46

VerifiedAnalyze and Optimize Storage Performance

Refer to the exhibit.

Question Image

A Microsoft SQL Server 2016 deployment is displayed in the exhibit. The administrator receives reports from users that database queries take too long to return.

Which optimization should be made to this configuration to improve performance?

Explanation

Database files, tempdb, and transaction logs have different and often competing I/O patterns. Placing each on its own disk isolates that I/O and reduces contention, improving SQL Server query performance. Microsoft storage guidance recommends separate storage for data and log files and isolated storage for tempdb when it cannot use ephemeral storage.

Learn more

Community Discussion

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