White Papers

Server configuration
15 65TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC
PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL
5 Server configuration
5.1 System BIOS
The system profile is set to Performance. All other options, outside of iDRAC configuration, were left at their
factory default settings. The Logical Processor option, under Processor Settings, is left at its default setting
of Enabled. This enables Intel
®
Hyper-Threading Technology, which maximizes the number of logical
processors available to SQL Server.
5.2 Host bus adapters
After each HBA port was reset to the factory defaults, several parameters were changed in accordance with
Dell EMC best practices for ME4 Series storage arrays. Those changes are detailed in Table 4.
QLogic HBA parameter changes
Parameter menu
Parameter
Setting
Adapter Settings
Connection Options
1 (Point to Point only)
Login Retry Count
60
Port Down Retry Count
60
Link Down Timeout
30