The table below describes the hardware and software components in this SRDF/Metro environment:
- A single-brick (one engine) PowerMax 8000 storage system includes: 1 TB raw cache, which is the smallest configuration for this system
- Two Dell R740 servers, each with 24 CPU cores and 256 GB RAM memory
- Windows Server 2019
- Microsoft SQL Server 2019
- HammerDB SQL Server benchmark to generate SQL Server workloads
Table 1. Hardware and software components
Storage system |
PowerMax 8000 storage system |
- 1 x brick, 1 TB raw cache
- 30 x NVMe NAND SSD
- 8 x NVMe SCM
|
PowerMaxOS Q3 2020 |
Database servers |
2 x Dell R740 |
- Each Dell server: 2 x Intel Xeon E5-2690v4 2.6GHz (total 24 cores), 256 GB RAM
|
Operating System (OS) |
Windows Server 2019 with failover clustering and MPIO |
Host bus adapater (HBA) |
Broadcom (Emulex) |
Each server: 2 x dual port 32 Gb HBAs (total of 4 initiator ports) |
2 x LPe32002 (per server) |
Microsoft SQL Server |
SQL Server |
Two-node SQL Server failover cluster |
SQL Server 2019 |
Benchmark tools |
OLTP |
OLTP: HammerDB 3.23 |
