Skip to main content

Dell PowerEdge R770 Server Database Workload Benchmarking using TPROC-C

Calsoft Inc. Heerak Surti Manya Rastogi Oct 1, 2026
Dell PowerEdge R770 Server Database Workload Benchmarking using TPROC-C

Executive Summary

This benchmarking report presents a structured evaluation of Dell’s PowerEdge R770 and R760 servers under scalable, real-world workloads. The assessment was conducted using VMware-based virtualization environments running MySQL databases with HammerDB load generators, modeled on TPROC-C benchmark protocols. 

Key performance indicators such as Transactions Per Minute (TPM), New Orders Per Minute (NOPM), and power consumption were measured across increasing concurrency and workload scales. The tests used a standardized configuration (including dual Intel Xeon processors with 32 cores per socket) to simulate realistic enterprise operations. 

The findings offer a comparative behavior profile between the two platforms, particularly across metrics like power efficiency, VM workload density, and concurrency performance—providing infrastructure teams with actionable reference points for planning and evaluation. 

What follows is a neutral benchmarking analysis based on consistent configurations. It presents a measurable behavior profile across server generations and offers a practical reference for infrastructure teams evaluating system performance, platform evolution, or deployment planning, particularly in contexts where performance per watt, VM density, and concurrency are becoming critical infrastructure traits.

This study was conducted with authorized collaboration and inputs from Dell Technologies and Intel, ensuring alignment with platform configurations and benchmark standards.

Testing Methodology

We conducted controlled benchmarking tests to assess how Dell PowerEdge R770 and R760 servers handle transaction-based workloads under repeatable, scalable conditions.

  • Test Environment Configuration: The testing setup consisted of paired MySQL database virtual machines and HammerDB-based workload generators running on a virtualized infrastructure using VMware ESXi environments. Each configuration was designed to maintain consistency in virtual machine count, concurrency levels, and test duration.
  • Key Metrics Captured: The benchmarking used the HammerDB tool configured to run workloads based on the TPROC-C protocol, which simulates transaction processing based on real-world scenarios. Each workload run involved a fixed number of virtual users and a defined number of warehouse units to simulate a realistic data and compute environment.  Alongside transactional throughput, power consumption during runtime was also tracked to provide insight into the performance-to-power behavior of the servers under scale. 
  • Benchmarking Tool: Measurements were taken for transactions per minute (TPM), new orders per minute (NOPM), execution power draw, and network throughput. The goal was to observe server behavior in consistent conditions across different scales, ranging from small to high concurrency levels.
  • Test Consistency: Each test iteration was conducted with the same control parameters to isolate the effect of server generation on performance, responsiveness, and resource usage.

Control measures

The test configuration was standardized on a 32-core CPU setup. This specification reflects the most commonly deployed core count in VMware-based virtualized environments, providing an appropriate balance between compute availability, licensing optimization, and scalability. By anchoring the benchmark on this configuration, the evaluation aligns with what infrastructure teams typically plan for in enterprise-grade deployments.

Here are the control parameters that defined our testing environment. These, as indicated before, were tweaked systematically to create credible and measurable observations.

Hardware Specifications Dell R770 (17G) Dell R760 (16G)
Processors
Number of processors 2 2
Vendor and model Intel Xeon 6737P Intel Xeon 6548N
Core count (per processor) 32 Core 32 Core
Memory
Total memory (GB) 1024 1024
Type and speed DDR5 RAM @ 6400 MT/s DDR5 RAM @ 4800 MT/s
Network
NIC 1x Broadcom BCM57608, 2x 100G OCPEthernet NIC 1x Broadcom NetXtreme GigabitEthernet (BCM5720), 2x Intel Ethernet 100G E810-CAdapter
Storage Controller
Vendor and Model BOSS-N1 DC-MHS BOSS-N1 Monolithic (Embedded)
OS Drive Storage
Number of drives 2 2
Type NVMe SSDs NVMe SSDs
Drive size (GB) 447.07 447.13
Data Drive Storage
Number of drives 6 3
Drive size (TB) 1.75 3.58
Power
Power supplies Delta 1500 Watt 2800 Watt
Operating System and Version
VMware vSphere 8.0U3  8.0U3
Red Hat Enterprise (64 bit) 9.1 9.1
Workload - HammerDB
Version TPROC-C 4.11 TPROC-C 4.11
Number of VMs
20 20
CPU per VM 16 16
Workload Parameters 128 warehouses, 128 virtual users, all_warehouse=true 128 warehouses, 128 virtual users, all_warehouse=true
RAM per VM (GB) 64 64
HD (GB) 100 100
Data and logs - MySQL
Version 8.0 8.0
Number of VM1 20 20
CPU per VM 16 16
RAM per VM (GB) 96 96
HD for OS installation (GB) 60 60
HD for data (GB) 300 300
Metric Definition Logic
VMs (SQL) Number of virtual machines running MySQL database instances Represents database processing scale; more VMs simulate distributed database environments
VMs (HammerDB) Number of virtual machines generating transactional load using HammerDB Controls how load is distributed; more VMs can reduce local bottlenecks on generators
Virtual Users Simulated users executing transactions concurrently Represents concurrency in real-world systems; a higher number simulates peak usage scenarios
Warehouses Logical units defined by the TPC-C workload, each with its own data subset Simulates dataset complexity and size; more warehouses result in greater I/O and processing overhead
Server Platform The hardware being tested (Dell PowerEdge R770 or R760) The primary comparison point; allows performance evaluation across generations
ESXi Version Hypervisor version under which the virtual machines run Determines virtualization layer behavior; included to assess consistency across environments

Observation metrics

Here are the metrics we tracked (observed) based on the changes to our control parameters.

Metric Definition Logic
TPM (Transactions Per Minute) Number of total transactions processed per minute Primary performance indicator showing how the system handles transactional load under concurrency
NOPM (New Orders Per Minute) Number of new order entries committed per minute Tracks write-intensive workload responsiveness; relevant for systems under transactional stress
Power Power consumed by the system during workload execution Used to compute operational efficiency across varying transactional loads

Correlation and derived efficiency metrics

Metric Definition Logic
TPM per Watt Ratio of TPM to power consumption Normalizes performance against power; used to evaluate energy efficiency at different loads
NOPM change with load Increase of NOPM with load (R770 vs R760) Tracks concurrency handling efficiency; higher values suggest better multi-user performance
TPM change with load Increase of TPMs with load (R770 vs R760) Measures virtualization efficiency per database instance
Correlation Coefficients Measures relationship between control inputs and performance metrics Indicates how system variables like VM count or user load affect transactional behavior and power use

Dell PowerEdge R770

A next-generation compute platform powered by Intel Xeon 6 processors (former codename Granite Rapids). Built for performance-intensive environments, the server supports high I/O throughput, accelerator integration, and scalable memory bandwidth. 

Ideal for workloads demanding concurrency stability, consistent virtualization output, and better power-to-performance efficiency under load.

Dell PowerEdge R760

An infrastructure-optimized server built for general-purpose workloads, offering dependable performance across virtualized and cloud-native operations - powered by Intel® Xeon® Gold processors. 

Designed to operate efficiently in constrained environments where space, power, and cost control are key factors.

Test Scenarios

All tests were conducted in a virtualized lab environment using ESXi infrastructure. SQL and HammerDB virtual machines were deployed in defined ratios to simulate real-world concurrency.

  • Each test maintained a consistent mapping of user load, VM count, and warehouse configuration.
  • Each test run was time-bound and triggered simultaneously across the SQL and load-generating VMs. The systems were left in a default state between runs to avoid environmental contamination.
  • The same test sequence was used across both server models. Metrics were captured during the test runtime and directly after completion. The testing software was configured to log throughput and new order rates, along with network statistics. Power readings were recorded at pre-execution to isolate base system draw.\Each test point was validated through a complete run; partial passes or failures were not included in the dataset. This allowed a consistent performance line to be plotted across increasing complexity levels, while keeping the test environment stable.

Results and Observations

Each test was conducted under the same load structure for both Dell PowerEdge R770 and R760 servers, enabling a direct comparison. Metrics such as TPM, NOPM, power draw, and throughput were used to assess core performance and efficiency patterns. Each test was conducted under the same load structure for both Dell PowerEdge R770 and R760 servers, enabling a direct comparison. Metrics such as TPM, NOPM, power draw, and throughput were used to assess core performance and efficiency patterns.

Correlation Basis Metric Peak Performance Inference
Concurrency scaling efficiency NOPM change +27.33%[1] Concurrency efficiency peaked under high user loads, showing robust multi-thread scaling in R770.
Workload density efficiency TPM change +27.32%[2] R770 handled more transactions with higher load (at scale), indicating better virtualization performance.
Efficiency to power ratio TPM/Watt +8.50%[3] Highest performance-per-watt improvement observed in R770 under moderate workload.

The results reflect consistent behavior under concurrency and scale, backed by the architectural strengths of Intel Xeon Scalable processors. These CPUs are designed to sustain throughput under multi-VM load conditions, with performance stability across workloads and runtime stages. The validated runs form a credible reference point for infrastructure evaluations.

NOPM change with increase in virtual users

Standouts in Dell PowerEdge R770

The Dell PowerEdge R770 showed measurable efficiency gains across key metrics, with up to 27.33%[1] improvement in NOPMs under high concurrency and sustained TPM gains across scaled workloads. These results were captured in controlled and scalable configurations.

While the overall power draw increased under load, the TPM per watt metric showed relative improvement under moderate workloads, aligning with expected energy efficiency gains in next-generation hardware. The system delivered consistent output across scale levels, supporting its role in environments where performance consistency is critical across dynamic operational states.

The R770’s performance trends suggest suitability for VM-dense, transactional, and hybrid workloads that demand throughput and control across distributed compute nodes.

Inferences and Conclusion

The gains observed in the R770 were not isolated to any one load profile. Instead, improvements were distributed across light to high-load scenarios, suggesting the system is structurally better suited for environments with variable demand. The correlation analysis supported this view, showing stable relationships between input controls (VMs, users) and output metrics (TPM, NOPM, power).

Persona Focus Area Observed Metric Used Practical Insight Deployment Relevance
CXOs Infrastructure return clarity TPM/Watt, TPM per SQL VM Higher efficiency per watt and per VM offers predictable output per asset invested Supports cost-based scaling and infrastructure ROI mapping
CIOs / Infra Heads Scalable performance planning NOPM change, Power draw R770 sustains throughput under growing user loads with stable power scaling Assists in refresh planning across dynamic loads
System Architects / Tech Leads Predictable system behavior TPM change, scalable increase (correlation) Scaling behavior remains consistent with increased VMs and concurrency Helps model workloads and define VM density rules
IT Ops / Infrastructure Admins Default performance reliability Raw TPM, controlled conditions Gains observed in realistic scenarios, implying out-of-box readiness Simplifies deployment and reduces setup overhead
DevOps / Platform Teams Resource isolation and distribution TPM/User, VMs vs throughput R770 handles heavier VM loads without transactional drop-off Supports container scheduling and API concurrency planning

These infrastructure traits - predictable scaling, consistent power-performance behavior, and I/O stability, also align with the baseline expectations of AI-adjacent workloads. While not tested explicitly for AI tasks, the R770’s behavior suggests readiness for environments where inference, streaming, or parallel compute tasks are evolving alongside traditional virtualized services.

Please also read the detailed science report (showcasing the deep logic and process followed during the benchmarking tests).

Appendix A - Testing environment assumptions

Assumption Area Assumption Description
Hypervisor settings VMware ESXi default scheduler and memory allocation; in realistic scenarios.
BIOS/firmware Factory-default BIOS settings for both servers, including CPU power profiles and turbo modes.
Cooling and power Standard data center airflow and ambient conditions; Smart Cooling active on R770.
Test workload parity Same HammerDB settings, virtual users, and transaction profiles applied across server generations.

References

1.    Based on Claim ID CLM-014581 – Testing was conducted by Calsoft with servers located in Dell Labs during the June 2025 timeframe. The R770 server was running 2-socket 6th Gen Intel® Xeon® 6737P CPUs with 32 Cores, compared to the R760 server running 2-socket 5th Gen Intel® Xeon® 6548N CPU with 32 cores.

2.    Based on Claim ID CLM-014582 – Testing was conducted by Calsoft with servers located in Dell Labs during the June 2025 timeframe. The R770 server was running 2-socket 6th Gen Intel® Xeon® 6737P CPUs with 32 Cores, compared to the R760 server running 2-socket 5th Gen Intel® Xeon® 6548N CPU with 32 cores.

3.    Based on Claim ID CLM-014583 – Testing was conducted by Calsoft with servers located in Dell Labs during the June 2025 timeframe. The R770 server was running 2-socket 6th Gen Intel® Xeon® 6737P CPUs with 32 Cores, compared to the R760 server running 2-socket 5th Gen Intel® Xeon® 6548N CPU with 32 cores.


Calsoft is a leading technology-first partner, providing digital and product engineering services. For over 25 years, Calsoft has been  helping its customers solve their business challenges using technologies in Storage, virtualization, networking, security, cloud, AI/ML, IoT, and telecommunication domains.

Write to us at: marketing@calsoftinc.com 

Website: www.calsoftinc.com