SPARC Enterprise M4000 PeopleSoft NA Payroll 240K Employees Performance (16 Streams)
By Brian Whitney on Jan 21, 2010
The Sun SPARC Enterprise M4000 server combined with Sun FlashFire technology, the Sun Storage F5100 flash array, has produced World Record Performance on PeopleSoft Payroll 9.0 (North American) 240K employees benchmark.
The Sun SPARC Enterprise M4000 server with four 2.53 GHz SPARC64 VII processors and the Sun Storage F5100 flash array using 16 job streams (payroll threads) is 55% faster than the HP rx6600 (4 x 1.6GHz Itanium2 processors) as measured for payroll processing tasks in the PeopleSoft Payroll 9.0 (North American) benchmark. The Sun result used the Oracle 11gR1 database running on Solaris 10.
The Sun SPARC Enterprise M4000 server with four 2.53GHz SPARC64 VII processors and the Sun Storage F5100 flash array is 2.1x faster than the 2027 MIPs IBM Z990 (6 Z990 Gen1 processors) as measured for payroll processing tasks in the PeopleSoft Payroll 9.0 (North American) benchmark. The Sun result use the Oracle 11gR1 database running on Solaris 10 while the IBM result was run with 8 payroll threads and used IBM DB2 for Z/OS 8.1 for the database.
The Sun SPARC Enterprise M4000 server with four 2.53GHz SPARC64 VII processors and a Sun Storage F5100 flash array processed payroll for 240K employees using PeopleSoft Payroll 9.0 (North American) and Oracle 11gR1 running on Solaris 10 with different execution strategies with resulted in a maximum CPU utilization of 45% compared to HP's reported CPU utilization of 89%.
The Sun SPARC Enterprise M4000 server combined with Sun FlashFire technology processed 16 Sequential Jobs and single run control with a total time of 534 minutes, an improvement of 19% compared to HP's time of 633 minutes.
Sun's FlashFire technology dramatically improves IO performance for the Peoplesoft Payroll 9.0 (North American) benchmark with significant performance boost over best optimized FC disks (60+).
The Sun Storage F5100 Flash Array is a high performance high density solid state flash array which provides a read latency of only 0.5 msec which is about 10 times faster than the normal disk latencies 5 msec measured on this benchmark.
Sun estimates that the MIPS rating for a Sun SPARC Enterprise M4000 server is over 3000 MIPS.
|System||Processor||OS/Database||Time in Minutes||Num of
|Run 1||Run 2||Run 3|
|Sun M4000||4x 2.53GHz SPARC64 VII||Solaris/Oracle 11gR1||43.78||51.26||286.11||534.35||16||9.0|
|HP rx6600||4x 1.6GHz Itanium2||HP-UX/Oracle 11g||68.07||81.17||350.16||633.25||16||9.0|
|IBM Z990||6x Gen1 2027 MIPS||Z/OS /DB2||91.70||107.34||328.66||544.80||8||9.0|
Note: IBM benchmark documents show that 6 Gen1 procs is 2027 mips. 13 Gen1 processors were in this config but only 6 were available for testing.
Results and Configuration Summary
1 x Sun SPARC Enterprise M4000 (4 x 2.53 GHz/32GB)
1 x Sun Storage F5100 Flash Array (40 x 24GB FMODs)
1 x Sun Storage J4200 (12 x 450GB SAS 15K RPM)
Solaris 10 5/09
Oracle PeopleSoft HCM 9.0 64-bit
Oracle PeopleSoft Enterprise (PeopleTools) 8.49.08 64-bit
Micro Focus Server Express 4.0 SP4 64-bit
Oracle RDBMS 220.127.116.11 64-bit
HP's Mercury Interactive QuickTest Professional 9.0
The PeopleSoft 9.0 Payroll (North America) benchmark is a performance benchmark established by PeopleSoft to demonstrate system performance for a range of processing volumes in a specific configuration. This information may be used to determine the software, hardware, and network configurations necessary to support processing volumes. This workload represents large batch runs typical of OLTP workloads during a mass update.
To measure five application business process run times for a database representing large organization. The five processes are:
Paysheet Creation: generates payroll data worksheet for employees, consisting of std payroll information for each employee for given pay cycle.
Payroll Calculation: Looks at Paysheets and calculates checks for those employees.
Payroll Confirmation: Takes information generated by Payroll Calculation and updates the employees' balances with the calculated amounts.
Print Advice forms: The process takes the information generated by payroll Calculations and Confirmation and produces an Advice for each employee to report Earnings, Taxes, Deduction, etc.
Create Direct Deposit File: The process takes information generated by above processes and produces an electronic transmittal file use to transfer payroll funds directly into an employee bank a/c.
For the benchmark, we collect at least three data points with different number of job streams (parallel jobs). This batch benchmark allows a maximum of sixteen job streams to be configured to run in parallel.
Key Points and Best Practices
Please see the white paper for information on PeopleSoft payroll best practices using flash.