By Brian-Oracle on Jun 10, 2011
Oracle's M-series server sets a world record on Oracle's PeopleSoft Enterprise Payroll (N.A) 9.1 with extra large volume model benchmark (Unicode). Oracle's SPARC Enterprise M5000 server was able to to run faster than the previous generation system result even though the PeopleSoft Payroll 9.1 benchmark is more computationally demanding.
Oracle's SPARC Enterprise M5000 server configured with eight 2.66 GHz SPARC64 VII+ processors together with Oracle's Sun Storage F5100 Flash Array storage achieved world record performance on the Unicode version of Oracle's PeopleSoft Enterprise Payroll (N.A) 9.1 with extra large volume model benchmark using Oracle Database 11g Release 2 running on Oracle Solaris 10.
The SPARC Enterprise M5000 server processed payroll payments for the 500K employees PeopleSoft Payroll 9.1 (Unicode) benchmark in 46.76 minutes compared to a previous result of 50.11 minutes for the PeopleSoft Payroll 9.0 (non-Unicode) benchmark configured with 2.53 GHz SPARC64 VII processors resulting in 7% better performance.
Note that the IBM z10 Gen1 mainframe running the PeopleSoft Payroll 9.0 (Unicode) benchmark was 48% slower than the 9.0 non-Unicode version. The IBM z10 mainframe with nine 4.4 GHz Gen1 processors has a list price over $6M and is rated at 6,512 MIPS.
The SPARC Enterprise M5000 server with the Sun Storage F5100 Flash Array system processed payroll for 500K employees completing the end-to-end run in 66.28 mins, 11% faster than earlier published result of 73.88 mins with Payroll 9.0 configured with 2.53 GHz SPARC64 VII processors.
The Sun Storage F5100 Flash Array device 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 of 5 msec measured on this benchmark.
PeopleSoft Payroll (N.A.) 9.1 – 500K Employees (7 Million SQL PayCalc, Unicode)
|SPARC M5000||8x 2.66GHz SPARC64 VII+||Solaris/Oracle 11g||46.76||66.28||32|
PeopleSoft Payroll (N.A.) 9.0 – 500K Employees (3 Million SQL PayCalc, Non-Unicode)
|System||Processor||OS/Database||Time in Minutes||Num of
|Run 1||Run 2||Run 3|
|Sun M5000||8x 2.53GHz SPARC64 VII||Solaris/Oracle 11g||50.11||73.88||534.20||1267.06||32|
|IBM z10||9x 4.4GHz Gen1||Z/OS /DB2||58.96||80.5||250.68||462.6||8|
|IBM z10||9x 4.4GHz Gen1||Z/OS /DB2||87.4 **||107.6||-||-||8|
|HP rx7640||8x 1.6GHz Itanium2||HP-UX/Oracle 11g||96.17||133.63||712.72||1665.01||32|
** This result was run with Unicode
Payroll 9.1 Compared to Payroll 9.0
Please note that Payroll 9.1 is Unicode based and Payroll 9.0 is non-Unicode. There are 7 million executions of an SQL statement for the PayCalc batch process in Payroll 9.1 and 3 million executions of the same SQL statement for the PayCalc batch process in Payroll 9.0. This gets reflected in the elapsed time (27.33 min for 9.1 and 23.78 min for 9.0). The elapsed times of all other batch processes is lower (better) on 9.1.
128 GB memory
2 x SAS HBA (SG-XPCIE8SAS-E-Z - PCIe HBA for Rack Servers)
PeopleSoft HRMS and Campus Solutions 9.10.303
PeopleSoft Enterprise (PeopleTools) 8.51.035
Oracle Database 11g Release 2 126.96.36.199 (64-bit)
Micro Focus COBOLServer Express 5.1 (64-bit)
The PeopleSoft 9.1 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 a large organization. The five processes are:
Paysheet Creation: Generates payroll data worksheets consisting of standard payroll information for each employee for a 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 the above processes and produces an electronic transmittal file that is used to transfer payroll funds directly into an employee's bank account.
For the benchmark, we collected at least three data points with different numbers of job streams (parallel jobs). This batch benchmark allows a maximum of thirty-two job streams to be configured to run in parallel.
- Oracle PeopleSoft Benchmark White Papers
- PeopleSoft Enterprise Payroll 9.1 using Oracle for Solaris (Unicode) on a Sun SPARC Enterprise M5000
- SPARC Enterprise M5000 server
- Sun Storage F5100 Flash Array
- Oracle Solaris
- PeopleSoft Enterprise
- Oracle Database 11g
Oracle's PeopleSoft Payroll 9.1 benchmark, SPARC Enterprise M5000 46.76 min, www.oracle.com/apps_benchmark/html/white-papers-peoplesoft.html, results 6/10/2011.