Home > Servers > Rack and Tower Servers > Intel > White Papers > Can newer Dell EMC servers offer significantly better performance for Microsoft SQL Server? > Measuring SQL Server performance
The goal of our testing was to generate performance data showing the NOPM performance of a SQL Server database running on each Dell EMC PowerEdge system. We also collected other performance data to verify that the two systems were operating as intended with comparable configurations.
For these tests, we used Benchcraft®, a Microsoft benchmarking tool that processes data similar to a TPC-C® benchmark. Note, Benchcraft does not conform to the TPC-C testing standards, and results between the two are not comparable. Both servers were configured with identical RAID settings, with the “logs” residing on a four-disk RAID 10 stripe, the “tmp” space configured on a RAID 0 stripe, and the “database” residing on a three-disk RAID 5 stripe.
We configured a SQL Server 2019 database with 1,400 warehouses and 100 threads. We allowed each test run about 30 minutes of run time until the database reached a steady state prior to recording new orders. Our engineers then recorded total new orders performed over a 15-minute period, and we then used simple division to calculate NOPM.
Our results show the median of three runs for each server, in order to compare performance between the two platforms.