Quest Benchmark Factory is a software program used to test database performance by simulating users and transactions. We used Benchmark Factory to simulate a transactional database workload. For example, the database workload is similar to business suites used to support back office operations. The Benchmark Factory TPC-E-like configuration included:
- A user load of 100 to generate the database workload
- Embedded wait time of 14 ms
- Scale factor of a 500 GB database
Benchmark Factory and Dell EMC Live Optics captured detailed performance metrics. From Benchmark Factory, we reviewed the following metrics:
- Transactions per second (TPS)—Number of transactions, or SQL statements, processed by the server per second. The greater the value of TPS, the faster the system is processing transactions.
- Bytes per second (BPS)—Number of bytes processed per second over the sampling period. The greater the value of BPS, the more data the system is processing.
From Live Optics, we reviewed the following metrics:
- Peak CPU (GHz)–High watermark of CPU utilization during the workload tests. This metric is useful because it shows the extent of CPU resource utilization during the tests.
- Average CPU (GHz)—Central CPU utilization during the workload tests. Average CPU utilization is useful because it shows the steady state of CPU usage during the tests.
- Peak IOPS—High watermark of IOPS during the workload tests. Analyzing IOPS with latency provides an accurate picture of storage performance.
- SQL Server average read latency—Wait time for the database to perform a physical read from storage. The lower the read latency, the faster the storage.
- SQL Server average write latency—Wait time for the database to perform a physical write from storage. The lower the write latency, the faster storage can acknowledge a write to the database.