Home > Servers > Rack and Tower Servers > Intel > Guides > Design Guide—VMware vSphere and Red Hat Enterprise Linux for High-Performance Database Applications > Design configuration and specifications
This Ready Stack for high-performance database applications provides flexibility to address both bare-metal and VM database cluster deployments.
Sizing a physical infrastructure for all workloads requires knowledge of all the individual workloads and their compute, memory, storage, and network performance requirements. This guide describes a database implementation with storage resources that can scale significantly as the database expands. For information about applying the described resources and methodologies to a larger-scale implementation, consult your Dell EMC Sales team.
This Ready Stack includes the following servers:
Consider these configuration recommendations when ordering the servers:
Table 2. Recommended capacity and quantity of database server memory DIMMs
Use case |
Server type |
Number of CPU sockets |
Number of DIMMs per populated channel |
Number of DIMMs per populated socket |
Capacity per DIMM |
Total physical DRAM |
OLTP PROD database |
R940 |
4 |
1 |
6 |
64 GB |
4 x 1 x 6 x 64 = 1,536 GB |
XVC databases |
R740 |
2 |
2 |
6 |
32 GB |
2 x 2 x 6 x 32 = 768 GB |
Databases on vSphere VMs |
R940 |
4 |
2 |
6 |
32 GB |
4 x 2 x 6 x 32 = 1,536 GB |
For more information about tuning the configuration of the Ready Stack components to meet infrastructure requirements, consult your Dell EMC Sales representative.
The following tables list the hardware details of the database servers that are used for physical production databases in this Ready Stack:
Table 3. Physical components for production database servers
Component |
Description |
Servers |
2 x PowerEdge R940 |
Chassis |
3U chassis with up to 24 hard drives |
Processors per server |
4 x Intel Xeon Gold 6150 18c 2.7 GHz |
Memory per server |
1,536 GB (24 x 64 GB QR DDR4 2,666 MT/s LRDIMMs) |
Local disks per server |
3 x 1.6 TB SAS 12 Gb/s 2.5 in. SSDs (R1 + 1 hot spare) |
RAID controller |
PERC H740P/H730P |
iDRAC |
iDRAC9 Enterprise |
rNDC |
Broadcom 5720 DP 1 Gb + 57412 DP 10 Gb NetXtreme-E |
Add-on NICs per server |
None |
HBAs per server |
2 x Emulex LPe31002-M6-D DP 16 Gb/s FC |
Power supplies per server |
2 x 1,600 W |
Table 4. Physical components for XVC database server
Component |
Description |
Server |
1 x PowerEdge R740 |
Chassis |
2U chassis with up to 16 hard drives |
Processors |
2 x Intel Xeon Gold 6136 12c 3.0 GHz |
Memory |
768 GB (24 x 32 GB DR DDR4 2,667 MT/s RDIMMs) |
Local disks |
3 x 1.6 TB SAS 12 Gb/s 2.5 in. SSDs (R1 + 1 hot spare) |
RAID controller |
PERC H740P |
iDRAC |
iDRAC9 Enterprise |
rNDC |
Broadcom 5720 DP 1Gb + 57412 DP 10Gb NetXtreme-E rNDC |
Add-on NICs |
None |
HBAs |
2 x Emulex LPe31002-M6-D DP 16 Gb/s FC |
Power supplies |
2 x 1,100 W |
Table 5. Physical components for optional VM-hosted database server
Component |
Description |
Server |
1 x PowerEdge R940 server |
Chassis |
3U chassis with up to 24 hard drives |
Processors |
4 x Intel Xeon Gold 6150 18c 2.7 GHz |
1,536 GB (48 x 32 GB DR DDR4 2,667 MT/s RDIMMs) |
|
Local disks |
3 x 1.6 TB SAS 12 Gb/s 2.5 in. SSDs (R1 + 1 hot spare) |
RAID controller |
PERC H740P |
iDRAC |
iDRAC9 Enterprise |
rNDC |
Broadcom 5720 DP 1Gb + 57412 DP 10Gb NetXtreme-E |
Add-on NICs |
None |
HBAs |
2 x Emulex LPe31002-M6-D DP 16 Gb/s FC |
Power supplies |
2 x 2,000 W |