Home > Workload Solutions > SQL Server > Guides > Reference Architecture Guide—Consolidate and Simplify Mixed Database Workloads > Use case 3: Snapshot OLTP workload using TPC-C–like benchmark
The third test creates storage snapshots of the Oracle and SQL Server databases running a light OLTP workload. The PowerMax 2000 storage array can take fast, write-consistent snapshots of databases using SnapVX. The DBA can then configure the snapshot databases and open them to the business. This database cloning approach enables the IT organization to quickly provision copies of production databases for test and development. In the snapshot OLTP database workload use case, we created snapshots of one Oracle and one SQL Server database from the baseline OLTP test database.
We ran the snapshot workload in parallel with the OLTP and DSS workloads to show the cumulative load that was placed on the database infrastructure. Because most test and development databases generate a lighter workload compared to production databases, we configured our snapshot database OLTP workload with low-level resources and load profiles as compared to the previous two use cases.
Table 5. TPC-C–like benchmark configuration for snapshot database use case
HammerDB TPC-C–like parameter |
SQL Server |
Oracle |
Total |
Database scale factor |
10,000 |
15,000 |
25,000 |
Database size (TB) |
1 |
1.5 |
2.5 |
Number of users |
25 |
25 |
50 |
Test duration (min) |
30 |
30 |