Home > Workload Solutions > SQL Server > Guides > Reference Architecture Guide—Ready Solutions for Microsoft SQL: Design for Dell EMC XtremIO > OLTP use case
Using Quest Benchmark Factory, we configured workloads to simulate many small environments. The TPC-E benchmark is an OLTP workload that the Transaction Processing Council (TPC) designed to test database performance with a mixture of read-only and update-intensive transactions. Our TPC-E-like database workload enables customers to objectively measure performance of the database infrastructure by simulating transactions in enterprise OLTP applications. The following table outlines our modified TPC‑E workload, which is not directly comparable to official benchmarks submitted to and validated by the TPC.
Table 8. Modified TPC-E workload for OLTP use case
Benchmark Factory TPC-E parameter |
Value |
Database scale factor |
105 |
Database size |
1,024 GB (1 TB) |
Number of users |
100 |
Keying time delay |
20 ms |
Think time delay |
20 ms |
Test duration |
10 min presampling and 20 min run time |