Enterprise-grade SSDs for High-Performance Transactional Databases

Enterprise SSDs for Transactional Databases

Prev Question Next Question

Question

An administrator has been tasked with making recommendations for purchasing disks that will support a transactional database where performance is of greatest concern and budget is secondary.

Which the following disk types should the administrator recommend?

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D.

C.

The recommended disk type for a transactional database where performance is the primary concern and budget is secondary is SAS (Serial Attached SCSI).

Here is a detailed explanation of each disk type:

A) FC (Fibre Channel): Fibre Channel is a high-speed network technology used to connect storage devices to servers. Fibre Channel disks are designed for high-end applications that require high speed, high availability, and high reliability. However, they are expensive and require specialized hardware and software.

B) iSCSI (Internet Small Computer System Interface): iSCSI is a network protocol used to transport block-level storage data over TCP/IP networks. iSCSI disks are cost-effective and can provide good performance, but they may not perform as well as Fibre Channel or SAS disks.

C) SAS (Serial Attached SCSI): SAS is a point-to-point serial protocol used to connect devices to a computer's motherboard. SAS disks offer high performance, reliability, and scalability. They are more expensive than SATA disks, but less expensive than Fibre Channel disks. SAS disks are typically used in high-performance, mission-critical applications such as transactional databases.

D) SATA (Serial Advanced Technology Attachment): SATA is a point-to-point serial protocol used to connect storage devices to a computer's motherboard. SATA disks are the most common type of hard drive used in desktop and consumer-grade storage systems. They are cost-effective, but not designed for high-performance applications such as transactional databases.

In summary, while Fibre Channel may offer the highest performance, its cost may be prohibitive. iSCSI is cost-effective, but may not offer the performance needed for a transactional database. SATA is not suitable for high-performance applications. SAS, with its balance of performance, reliability, and cost, is the best choice for a transactional database where performance is the primary concern and budget is secondary.