Home > Workload Solutions > SQL Server > White Papers > Deploying Dell EMC SRDF/Metro Smart DR with Microsoft SQL Server for Physical and Virtual Environments > Hardware and software components
The table below describes the hardware and software components that were used for our Microsoft SQL Server testing using SRDF/Metro on PowerMax.
Table 2. Hardware and software used for testing
Category |
Type |
Quantity/size |
Release |
Storage system |
PowerMax 8000 storage system |
1 x brick, 1 TB raw cache 20 x NVMe NAND SSD 8 x NVMe SCM |
PowerMaxOS 5978 Q3 2020 Release |
Database servers |
1 x Dell PowerEdge R740 |
Dell server: 2 x Intel Xeon Gold 6248 2.5GHz (total 40 cores), 512 GB RAM |
|
Operating System (OS) |
Windows Server 2019 with failover cluster |
||
Ethernet adapater for iSCSI |
Broadcom Adv. |
One dual port 25GbE adapter (total of 2 initiator ports) |
|
Multipathing |
Windows MPIO |
On Windows Server |
|
Microsoft Application |
Microsoft SQL Server |
Failover Cluster SQL Server instance |
Microsoft SQL Server 2019 |
Benchmark tool |
OLTP |
OLTP: HammerDB v3.3 |
On the SQL Server database, we configured eight file groups on 200 GB Data devices and one 150 GB Log device. The total allocated capacity was 1.2 TB.
For the tests, we used eight physical paths per device supported by MPIO’s default round robin path selection policy.