Starting with 12th Generation processors, Intel introduced its Performance Hybrid Architecture combining P-Cores (Performance Cores) and E-Cores (Efficient Cores).
Why SQL Server Needs Tuning on Hybrid CPUs
When SQL Server schedules heavy database threads across E-Cores or mixes thread scheduling across different core types, query latency can increase noticeably. By configuring Processor Affinity and enabling Boost SQL Server Priority on performance cores inside SQL Server Management Studio (SSMS), you ensure that Xtra ERP database queries always execute at peak clock speed.
Recommended Steps
- Open SQL Server Management Studio (SSMS) and right-click the server instance → Properties.
- Go to the Processors page and enable Boost SQL Server priority.
- Configure CPU Affinity to prioritize high-performance P-Cores for heavy accounting and inventory workloads.
