Home > Servers > Systems Management > White Papers > PowerEdge BIOS Performance and Workload Tuning Guide for 16G > Database optimized
| BIOS Default | Database Optimized Performance Profile | Database Optimized Performance Per Watt Profile | |
System Setup Screen | BIOS Attribute Name | BIOS Default Setting | Profile Setting | Profile Setting |
Memory Settings | Memory Operating Mode | Optimizer Mode | Optimizer Mode | Optimizer Mode |
Node Interleaving | Disabled | Disabled | Disabled | |
Processor Settings | Logical Processor | Enabled | Enabled | Enabled |
Cpu Interconnect Speed | Maximum data rate | Maximum data rate | Maximum data rate | |
Virtualization Technology | Enabled | Disabled | Disabled | |
Sub NUMA Cluster | Disabled | Disabled | Disabled | |
MADT Core Enumeration | Round Robin | Round Robin | Round Robin | |
UPI Prefetch | Enabled | Enabled | Enabled | |
XPT Prefetch | Enabled | Enabled | Enabled | |
LLC Prefetch | Enabled | Enabled | Enabled | |
Dell Controlled Turbo | Disabled | Disabled | Disabled | |
Number of Cores Per Processor | All | All | All | |
Hardware Prefetcher | Enabled | Enabled | Enabled | |
DCU Streamer Prefetcher | Enabled | Enabled | Enabled | |
DCU IP Prefetcher | Enabled | Enabled | Enabled | |
x2APIC | Enabled | Enabled | Enabled | |
AVX ICCP Pre-Grant License | Disabled | Disabled | Disabled | |
AVX ICCP Pre-Grant Level | 128 Heavy | 128 Heavy | 128 Heavy | |
CPU Physical Address Limit | Enabled | Enabled | Enabled | |
Dead Line LLC Alloc | Enabled | Enabled | Enabled | |
Directory AtoS | Disabled | Disabled | Disabled | |
Directory Mode | Enabled | Enabled | Enabled | |
Kernel DMA Protection | Disabled | Disabled | Disabled | |
Local Machine Check Exception | Enabled | Enabled | Enabled | |
Adjacent Cache Line Prefetch | Enabled | Enabled | Enabled | |
AVX P1 | Normal | Normal | Normal | |
Intel SST-CP | Disabled | Disabled | Disabled | |
Dell Controlled Turbo Setting | Disabled | Disabled | Disabled | |
Processor N Controlled Turbo | Disabled | Disabled | Disabled | |
Logical Processor Idling | Disabled | Disabled | Disabled | |
Integrated Devices | Memory Mapped I/O above 4GB | Enabled | Enabled | Enabled |
Embedded NIC1 and NIC2 | Enabled | Enabled | Enabled | |
I/O Snoop HoldOff Response | 2K Cycles | 2K Cycles | 2K Cycles | |
System Profile Settings | System Profile | Performance Per Watt (DAPC) | Performance | Performance Per Watt (DAPC) |
CPU Power Management | System DBPM (DAPC) | Controlled by System Profile (MaxPerf) | Controlled by System Profile (System DBPM (DAPC) | |
Memory Frequency | MaxPerf | Controlled by System Profile (MaxPerf) | Controlled by System Profile (MaxPerf) | |
Turbo Boost | Enabled | Controlled by System Profile (Enabled) | Controlled by System Profile (Enabled) | |
Energy Efficient Turbo | Enabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Enabled) | |
C1E | Enabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Enabled) | |
C State | Enabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Enabled) | |
Write Data CRC | Disabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Disabled) | |
Memory patrol Scrub | Standard | Controlled by System Profile (Standard) | Controlled by System Profile (Standard) | |
Memory Refresh Rate | 1x | Controlled by System Profile (1x) | Controlled by System Profile (1x) | |
Uncore Frequency | DynamicUFS | Controlled by System Profile (MaxUFS) | Controlled by System Profile (DynamicUFS) | |
Custom Uncore Frequency | n/a | n/a | n/a | |
Energy Efficient Policy | BalancedPerformance | Controlled by System Profile (MaxPower) | Controlled by System Profile (BalancedPerformance) | |
Monitor/Mwait | Enabled | Controlled by System Profile (Enabled) | Controlled by System Profile (Enabled) | |
CPU Interconnect Bus Link Power Management | Enabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Enabled) | |
PCI ASPM L1 Link Power Management | Enabled | Controlled by System Profile (Disabled) | Controlled by System Profile (Enabled) | |
Workload Configuration | Balance | Controlled by System Profile (Balance) | Controlled by System Profile (Balance) | |
Boot Settings | Boot Sequence Retry | Enabled | Enabled | Enabled |
Network Settings | PXE Device1 | Enabled | Enabled | Enabled |