Dell PowerEdge R640 55TB Data Warehouse Fast Track Reference Architecture for - Page 15

Server configuration 5 Server configuration 5.1 5.2 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. 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 Adapter Settings Connection Options Login Retry Count Port Down Retry Count Link Down Timeout Setting 1 (Point to Point only) 60 60 30 15 55TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R640 and Dell EMC PowerVault ME4024 | 3918-RA-SQL