Skip To Main Content
Support Knowledge Base

How to Resolve Latency Issues with Microsoft* SQL Servers on M50CYP Family

Content Type: Troubleshooting   |   Article ID: 000089869   |   Last Reviewed: 07/29/2022

Description

  • Experienced considerable speed problems when writing a lot of small packages to various data carriers connected Intel® M50CYP Server Board Family.
  • Noticed latency of 40-45 seconds depending on the drive model.

Resolution

  1. Reset BIOS to default and change the following settings:

    Advanced>Processor configuration>LLC Prefetch - Disabled
    Advanced>Power and Performance>CPU P state control> Energy Efficient Turbo - Disabled
    Advanced>Power and Performance>Hardware P states - Disabled
    Advanced>Memory Configuration>Memory RAS and Perf Config >Patrol Scrub - Disabled
    Advanced>Power and Performance>CPU C state Control>Package C state - Disabled
    Advanced>Power and Performance>CPU C state Control>C1E- Disabled
    Advanced>Power and Performance>CPU C state Control> Processor C6 - Disabled

  2. Save changes and reboot your system.

Additional information

BIOS default settings can be restored with F9 key.

Related Products

This article applies to 1 products.