Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
Attribute | Value |
---|---|
Product Name | SQL Server |
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 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:
GetMemoryErrorHandlingCapabilities
RegisterBadMemoryNotification
BadMemoryCallbackRoutine
SQL Server 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:
<Datetime> Server Machine supports memory error recovery. SQL memory protection is enabled to recover from memory corruption.
Check if you are encountering other errors like 855 and 856 and take appropriate corrective action.
You can use SQL Server trace flag 849 to keep SQL Server from registering with the operating system for memory error notifications. However, be aware that enabling trace flag 849 will prevent SQL Server from receiving bad memory notifications from operating system. Therefore, we do not recommend that you use this trace flag under typical circumstances.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today