Home > Workload Solutions > SQL Server > Guides > Design Guide—Ready Bundle for Microsoft SQL Server 2016 > Sample implementation: OLTP workload
This sample implementation is for an OLTP workload supporting up to 10,700 transactions on a database size of up to 2.4 TB. Figure 3 shows the architecture for this sample implementation.
Figure 3. Workload solution architecture
Table 3 lists the components for this implementation.
Table 3. Workload solution components
Component |
Specifications |
Servers |
2 x Dell EMC PowerEdge R740 |
Network switches |
2 x Dell EMC Networking S4048-ON |
FC switches |
2 x Brocade 6505 |
External storage |
|
Unity 400 Hybrid Flash storage details |
|
Per server |
|
Processor |
2 x Intel Xeon 8180 Scalable family; 2.5 GHz, 28 cores |
Memory (RAM) |
768 GB (24 x 32 GB, 2,666 MT/s DIMM) |
Network interface |
Broadcom 10 GbE BCM5720 |
FC HBA |
2 x 16 Gb FC (GFC) Emulex LightPulse LPE31002 |
Table 4 lists the workload implementation details.
Table 4. Workload implementation details
Component |
Value |
Number of VMs |
4 |
Number of database LUNs |
4 |
Number of log LUNs |
4 |
Number of tempdb LUNs |
4 |
Maximum database transactions/s |
10,700 |
Per VM configuration |
|
vCPUs |
24 |
Memory |
160 GB |
Memory for database |
128 GB |
Size of database LUN |
600 GB |
Size of log LUN |
100 GB |
Size of tempdb LUN |
100 GB |