Reports & Publications

Dell PowerEdge R760 Rack Server & Emulex LPe36002 HBA 64G Fibre Channel Oracle Database/Microsoft SQL Performance - NVMe/FC vs. SCSI/FC

Sponsor: Dell Technologies
Dell PowerEdge R760 Rack Server & Emulex LPe36002 HBA 64G

Abstract

New generation servers can bring higher performance across a range of areas. This is certainly the case with Dell’s 16th-generation server line. Similarly, newer protocols like NVM Express (NVMe) over Fibre Channel (FC) can provide greater throughput and efficiency than older SCSI over FC. Dell is unique in offering an end-to-end NVMe/FC connectivity solution in the mid-range storage marketplace with the PowerStore line.

Dell commissioned Tolly to benchmark the performance of the Broadcom Emulex LPe36002 64G Fibre Channel dual-port host bus adapter (HBA) running in the Dell PowerEdge R760 Rack Server by testing on actual database applications rather than simulated IO microbenchmarks. Testing focused on evaluating the database throughput, latency, and CPU efficiency of accessing both Oracle Database 19c and Microsoft SQL Server 2019 for Linux systems over older SCSI/FC and newer NVMe/FC. Databases were stored on a Dell PowerStore 9200T storage appliance.

Tests showed significant improvements in transaction throughput, latency reduction, and CPU efficiency.