Dell PowerEdge R940 385TB Data Warehouse Fast Track Reference Architecture for - Page 17

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 SC Series storage arrays. Those changes are detailed in Table 55. HBA parameter changes Parameter menu Parameter Adapter Settings Connection Options Setting 1 (Point to Point only) Advanced Adapter Settings Login Retry Count 60 Port Down Retry Count 60 Link Down Timeout 30 Enable LIP Reset Yes 17 385TB Data Warehouse Fast Track Reference Architecture for Microsoft SQL Server 2017 using Dell EMC PowerEdge R940 and SC9000 | 4032-RA-SQL