I just started getting touch to the brand new SQL Server 2014 with my VirtualBox virtual machine. The first thing to to with SQL Server 2014 is to test out the new in-memory OLTP functionality (of course!). So I did and immediately faced challenges. I followed the SQL Server team blog instructions and noticed that “MEMORY OPTIMIZED DATA” -section in Filegroup properties was missing completely. I tried to run the scripts provided and then got this error message:
Msg 41342, Level 15, State 1, Line 5
The model of the processor on the system does not support creating filegroups with MEMORY_OPTIMIZED_DATA. This error typically occurs with older processors. See SQL Server Books Online for information on supported models.
Looks like I wasn’t the only one around having the same issue because it had to to something with VirtualBox default settings for a new virtual machine. So, if you want to get the new in-memory OLTP functionality working correctly with VirtualBox you need to run the following command with VBoxManage:
VBoxManage setextradata [vmname] VBoxInternal/CPUM/CMPXCHG16B 1
July 5th, 2013 at 09:48
Hello, Greeny Dangerous. It’s awesome to see there is wonderful paper from you to explain how to solve this in-memory issue on Oracle Virtualbox. From my end , there is the same issue on Oracle VirtualBox 4.2.14. Fortunately , I just update the last Oracle virtualbox 4.2.16 and verified again. It’s amazing to see the issue has been solved automatically. from Lewis Yang @ MVP of SQL Server