70-332 · Question #63
You need to configure SPS-DB01. Which type of storage solution should you implement?
The correct answer is A. Multiple disks individually attached via Fibre Channel. Fibre Channel with individually attached disks provides the lowest latency and highest throughput for a SQL Server database server, while RAID 0 and RAID 5 introduce unacceptable reliability or performance trade-offs.
Question
Options
- AMultiple disks individually attached via Fibre Channel
- BMultiple disks configured in a RAID 0 array
- CMultiple disks individually attached via iSCSI
- DMultiple disks configured in a RAID 5 array
How the community answered
(19 responses)- A79% (15)
- B5% (1)
- C11% (2)
- D5% (1)
Why each option
Fibre Channel with individually attached disks provides the lowest latency and highest throughput for a SQL Server database server, while RAID 0 and RAID 5 introduce unacceptable reliability or performance trade-offs.
Fibre Channel (FC) uses a dedicated, low-latency storage network that delivers consistent high throughput and sub-millisecond response times essential for SQL Server I/O. Presenting each disk individually as a separate LUN gives the administrator full control over disk layout and allows SQL Server best practices such as separating data, log, and tempdb onto distinct spindles without the write penalties of software RAID.
RAID 0 provides no fault tolerance - a single disk failure causes complete data loss, making it unsuitable for any production database server.
iSCSI transmits SCSI commands over TCP/IP, introducing higher latency and CPU overhead compared to Fibre Channel, which is a less optimal choice for high-performance SQL Server workloads.
RAID 5 imposes a significant write penalty due to parity recalculation on every write, which degrades SQL Server transaction log and data file performance under heavy write workloads.
Concept tested: Fibre Channel storage for SQL Server database performance
Source: https://learn.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server
Topics
Community Discussion
No community discussion yet for this question.