Home > Workload Solutions > SQL Server > Guides > Reference Architecture Guide—Implementing SQL Server 2022 on Dell Integrated System for Azure Stack HCI > Methodology for testing
Our methodology to evaluate SQL Server 2022 on the DIS for Azure Stack HCI platform included setting up a test environment. We created a test environment which included three VMs with SQL Server 2022 installed on Windows Server 2022.
HammerDB is an open-source tool used for benchmarking different types of database solutions. For more information, see the HammerDB website.
The TPROC-H benchmark was used for our tests. This benchmark is an Online Analytics Processing (OLAP) benchmarking standard derived from the TPC-H standard. Our tests included a dataset with 1000 Scale factor. This resulted in a database sized at 1.5TB. These tests were initially performed with a single VM and then scaled to measure performance.
Each of the databases had their files on a dedicated fixed size Resilient File System (ReFS) volume which included two data files within the same file group and a log file. Each of these volumes were created as three-way mirrors to maximize performance.
For every VM, we dedicated 22 vCPU and 792 GB of memory. For our tests, we set the minimum and maximum memory for SQL Server to 728GB.