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

Prowess testing showed significantly more new orders per minute (NOPM) and faster RAID rebuild times after upgrading older servers to Dell EMC™ PowerEdge™ R750 servers built with 3rd Generation Intel® Xeon® Scalable processors, fast NVM Express® (NVMe®) solid-state drives (SSDs), and the latest-generation Broadcom® RAID controllers.

Executive Summary

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, andRAID controllers. Dell EMC™ PowerEdge™ R750 platforms offer several performance advantages for SQL Server over previous-generation platforms, including 3rdGeneration Intel® Xeon® Scalable processors, NVM Express® (NVMe® ) RAID drives,3,200 mega transfer per second (MT/s) memory, PCIe® Gen4 interfaces, and the Dell™PowerEdge RAID Controller (PERC) 11 H755N. But can these advanced components justify a platform upgrade when it comes to SQL Server performance? ProwessConsulting ran database performance tests to find out.

Our results showed a 14x gain in new orders per minute (NOPM) for the newerDell EMC™ platform, compared to the older-generation system that we tested.In addition, rebuild times for the RAID array were up to 5.25x faster for the newer server platform.