Which of the following is not a recommended optimization technique for SQL Server?

The correct answer is B. Store Data and Log files the same physical disks. Writing log files is a sequential process. Where as the data files are mostly random in nature. Using two separate physical disks help the log disk to track sequentially.

Design an optimized database solution

Question

Options

AUse a RAID 10 configuration on the server
BStore Data and Log files the same physical disks
CUse regular transaction log backups instead of full backups
DUse multi core processors instead of single core

How the community answered

(40 responses)

A
13% (5)
B
80% (32)
C
5% (2)
D
3% (1)

Explanation

Writing log files is a sequential process. Where as the data files are mostly random in nature. Using two separate physical disks help the log disk to track sequentially.

Topics

#RAID configuration#disk I/O optimization#storage layout#performance tuning

Community Discussion

No community discussion yet for this question.

Full 70-450 Practice