MSSQLSERVER_41342

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Details

Product Name

SQL Server

Event ID

41342

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

HK_HW_NOT_SUPPORTED

Message Text

The model of the processor on the system does not support creating construct. This error typically occurs with older processors. See SQL Server Books Online for information on supported models.

Explanation

Memory-optimized tables require a processor model that supports atomic compare-and-exchange operations on 128-bit values, which require the assembly instruction CMPXCHG16B. Certain older AMD processor models do not support the CMPXCHG16B instruction. Also, certain virtualization environments do not enable this instruction by default.

User Action

Upgrade your processor. If your processor supports the instruction and you are running SQL Server in a virtual machine, change the configuration to support the instruction CMPXCHG16B.

See Also

Concepts

In-Memory OLTP (In-Memory Optimization)