Your Browser is Out of Date

ShareDemos uses technology that works best in other browsers.
For a full experience use one of the browsers below
Design Guide—Ready Bundle for Microsoft SQL Server 2016
Solution Configuration Best Practices and Sizing
Server configuration Network configuration Storage configuration Solution sizing

Solution Configuration Best Practices and Sizing

Server configuration

  • The following outlines the Dell EMC recommended practices for configuring the servers:

    • Use the latest BIOS and firmware for Dell EMC PowerEdge servers.
    • Use the latest vendor-subscribed HBA drivers.
    • Enable Intel Hyper-Threading, which doubles the number of available cores and enables SQL Server to make best use of compute resources and deliver better performance.
    • Configure the power plan as follows:
    • In the system firmware:

    i             Go to System Setup > System BIOS > System Profile Settings, and select Performance Per Watt Optimized (DAPC) from the drop-down list.

    ii            Go to System Setup > System BIOS > Processor Settings > Dell Controlled Turbo, and select Enabled.

    • In the operating system: Go to Control Panel > Power Plans Scheme, and select High Performance Plan.

next

Network configuration