Главная » Новые поломки » Memory error address

Memory error address


Assume that you install the 64-bit version of Microsoft SQL Server 2014, 2016 or 2017 on a computer that’s running Windows Server 2012 or an earlier version of Windows operating system. When SQL Server uses up all the user-mode virtual address space, you may receive an out of memory error message in the SQL Server error log. Additionally, queries take a long time to finish execution, and the SOS_MEMORY_TOPLEVELBLOCKALLOCATOR wait occurs.

When you examine the following information points, you will find that there is very low available virtual address space:

  • DBCC MEMORYSTATUS – Process/System Counts section – Available Virtual Memory

  • DMV: sys.dm_os_process_memory – column virtual_address_space_available_kb

These values start off around 8 terabytes (TB) on an x64 process and continue to climb down and reach a few gigabytes (GB).

When you are at the stage where the available virtual address space is very low, queries that try to perform memory allocation may also encounter a wait type of CMEMTHREAD.

The following data points will continue to increase over time:

  • DMV: sys.dm_os_process_memory and sys.dm_os_memory_nodes – column virtual_address_space_reserved_kb

  • DBCC MEMORYSTATUS – Memory Manager section – VM Reserved

These values will typically increase in multiples of the “max server memory” value up to almost 8 TB.

Note Related issue is also described in KB 3074434


This update is included in the following cumulative updates for SQL Server:

      Cumulative Update 4 for SQL Server 2017

      Cumulative update 8 for SQL Server 2016 SP1  

      Cumulative Update 10 for SQL Server 2014 Service Pack 2

How do I fix the memory errors?
  1. Replace the RAM modules (most common solution)
  2. Set default or conservative RAM timings.
  3. Increase the RAM voltage levels.
  4. Decrease the CPU voltage levels.
  5. Apply BIOS update to fix incompatibility issues.
  6. Flag the address ranges as ‘bad’
Error message prior to bootup into windows
Memory address line failure at 0a3cc010, read c3c382c3 expecting c3c3c3c3
Decreasing available memory
Strike F1 key to continue, F2 to run setup utilities.
Description of problem
After Bios update, the given error shows up. Bios downgrade does not remove the problem. Windows uses only 164MB of available 1GB RAM.
Steps that caused problem, steps taken after problem
Initially existing Bios version: A05
I upgraded bios to A08 after getting the recommended bios for this system through file I5160A08.exe.
System gave memory error at bootup. F1 key allows bootup into windows. But system properties in Win. XP showed only 164MB of RAM is used.
Downgraded to bios version A07, no change in error
Downgraded to bios version AO5 (original bios version), still no change in error.
All bios changes were done with extreme caution.
1 Звезда2 Звезды3 Звезды4 Звезды5 Звезд (Пока оценок нет)

Добавить комментарий