Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > Baseline configuration
This section covers details of the baseline configuration. A baseline configuration was used to determine the initial workload and provide a comparison for the first set of best practices. After each test the database was refreshed with the best practices retained. This test methodology allowed the team to compare results as best practices were progressively added to the database.
The baseline BIOS settings for the two PowerEdge R750xs servers are described in the following table.
BIOS subgroup | Setting name | Baseline Setting (Default) |
Processor Settings
| Virtualization Technology | Enabled |
Logical Processor | Enabled | |
Sub NUMA Cluster | Disabled | |
Turbo Boost | Enabled | |
X2APIC | Enabled | |
Dell Controlled Turbo | Disabled | |
Memory Setting
| Node Interleave (NUMA) | Disabled |
Memory Operating Mode | Optimizer Mode | |
NUMA Fault Resilient Memory (size) | 25 (not changeable) | |
Security Setting | TPM Security | Off |
System Profile Settings | Workload profile | Not configured |
Trusted Platform Module Info | No TPM present | |
Turbo Boost | Enabled | |
System Profile | Performance Per Watt Optimized (DPAC) |
To check or change these BIOS settings, login to iDRAC and perform the following steps:
Select Configuration > Process Setting
Select Configuration > Memory Setting
Select Configuration > System Security
Select Configuration > Process Setting
Select Configuration > System Profile Settings