Home > Servers > Rack and Tower Servers > Intel > White Papers > Can newer Dell EMC servers offer significantly better performance for Microsoft SQL Server? > Significant performance boost justifies an upgrade
Organizations are looking to maximize actionable information from massive and growing data volumes. For the SMBs that run SQL Server databases on self-contained systems, the challenge is to maximize performance while ensuring all data is available and protected in the event of a drive failure. To address this challenge, businesses require modern platforms configured with high-performing processors, storage, interfaces, and controllers.
Testing by Prowess Consulting shows that the Dell EMC PowerEdge R750 server with RAID storage based on NVMe helps meet this requirement by providing critical protection for data, with significant improvements for database new order transactions and database rebuilds compared to older-generation servers built with SATA RAID drives.
The newer platform processed more than 7x more NOPM, compared to the older generation platform. In addition, RAID array rebuild times were up to 5.25x faster on the newer platform, due to efficiencies provided by the Dell PERC H755N, utilizing Broadcom RAID technologies.
For detailed testing methodology and configurations used in this study, see the Dell EMC PowerEdge R740xd server versus Dell EMC PowerEdge R750 server benchmark methodology report.
Dell EMC PowerEdge R750 Specification Sheet: https://i.dell.com/sites/csdocuments/Product_Docs/en/ poweredge-R750-spec-sheet.pdf