monitor
#monitor#854

854

Product Name

Event ID

854

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

HARDWARE_MEMORY_SCRUBBER

Message Text

Machine supports memory error recovery. SQL memory protection is enabled to recover

from memory corruption

This message indicates the hardware in the operating system supports the ability to recover

from memory errors. On computers that have newer hardware and are running Windows

Server 2012 or a later version, the hardware can notify the operating system and applications

that memory pages (operating system pages) are marked as bad or damaged. Applications

such as SQL Server can register these bad memory page notifications by using the following

API set:

adds support for these notifications in Microsoft SQL Server 2012 and later

versions. During SQL Server startup, SQL Server checks whether the hardware supports this

new feature. Additionally, you receive the following message in the error log:

Server Machine supports memory error recovery. SQL memory protection is

enabled to recover from memory corruption.

Expand table

GetMemoryErrorHandlingCapabilities
RegisterBadMemoryNotification
BadMemoryCallbackRoutine