Home > Workload Solutions > SQL Server > White Papers > Running SQL Server 2022 with Red Hat OpenShift on AMD EPYC based Dell PowerEdge servers and Dell ObjectScale > TPC-DS
For our validation, we used the industry standard TPC-DS. TPC-DS is a decision support benchmark that models several applicable aspects of a decision support system, including queries and data maintenance. The benchmark provides a representative evaluation of performance as a general-purpose decision support system. A benchmark result measures query response time in single user mode, query throughput in multiuser mode, and data maintenance performance for a given hardware, operating system, and data processing system configuration under a controlled, complex, multi-user decision support workload.
For more information about TPC-DS benchmarking, table structure, queries templates, and specification, see TPC Benchmark DS – Standard Specification.
We have generated a TPC-DS dataset using the dsdgen.exe cli tool provided by TPC.org. Figure 6 shows an example of a sample data file.
After the data files were generated for all tables, we moved these files to the ObjectScale bucket. We used the AWS cli tool to copy the files using the following sample command format. For more information about awl_cli, see Install or update the latest version of the AWS CLI.
aws s3 cp C:\tpcds\sf1000\data\Final\ s3://tpcds/sf1000/dat/ --recursive --endpoint-url https://10.230.96.136 --no-verify-ssl
Figure 7 shows a screenshot from the ObjectScale bucket “tpcds” (under directory /sf1000/dat) using S3 Browser UI tool. For more information about the S3 Browser UI tool, see the S3 Browser webpage.