Dell EMC PowerEdge R750 Servers with NVMe® RAID Unleash Microsoft® SQL Server® Database Performance

Remove performance bottlenecks, expand database capacity, and reduce rebuild times with Dell EMC PowerEdge R750 servers built with 3rd Generation Intel® Xeon® Scalable processors, fast NVM Express® (NVMe) SSDs, and the latest generation of RAID controllers based on Broadcom® technologies.

Countless small-to-medium-sized businesses (SMBs) rely on Microsoft® SQL Server® for daily operations. Because it’s common for these organizations to run SQL Server on a standalone platform, the performance of that platform is critical to keeping up with the massive growth of actionable data needed for business success. In addition, the RAID controller is also a key component on these systems because the data must be protected from drive failures.

Given these requirements, it’s clear that the overall performance of SQL Server depends on the server hardware, particularly the processor, memory, networking, and storage. To examine the benefits of upgrading hardware in greater detail, Prowess Consulting compared the latest generation of the popular 2U Dell EMC™ PowerEdge™ rack server with the previous-generation. Dell EMC PowerEdge R750 platforms offer several performance advantages for SQL Server over previous generation platforms, including 3rd Generation Intel® Xeon® Scalable processors, 3,200 megatransfers per second (MT/s) memory, PCIe® Gen4 interfaces, and the Dell™ PowerEdge RAID Controller (PERC 11) H755N Front NVM Express® (NVMe®) built with industry-leading Broadcom® RAID technologies. Prowess testing compared these components in the current-generation Dell EMC PowerEdge R750 server against the 2nd Generation Intel Xeon Scalable processors, single RAID controller, and Serial ATA (SATA®)-based solid-state drives (SSDs) found in the previous-generation Dell EMC PowerEdge R740xd platform. The testing allowed us to quantify what upgrading server infrastructure can mean for SMBs.