Home > Workload Solutions > SQL Server > Guides > Microsoft SQL 2019 on Intel Optane Persistent Memory (PMem) Using Dell PowerEdge Servers > Benchmarking configuration
We used HammerDB version 3.3 to assess the capabilities and impact of Intel Optane PMem with SQL Server 2019.
The following table shows the HammerDB benchmarking parameter settings that we used:
Use case | Parameter settings | Value |
PMem in App Direct Mode | Number of data warehouses (Scale Factor) | 1000 |
Database size | ~ 1 TB | |
Number of streams (Users) for Power Run | 1 | |
Number of streams (Users) for throughput Run | 7 | |
Database Indices | Column store | |
PMem in Memory Mode | Number of data warehouses (Scale Factor) | 3000 |
Database size | ~ 3 TB | |
Number of streams (Users) for Power Run | 1 | |
Number of streams (Users) for throughput Run | 8 | |
Database Indices | Column store |