Once I completed deploy SQL Server 2014 CTP1 on the following environment.
0. VM : Oracle VirrtualBox 4.2.14
1.Host OS : Windows 7(Lenovo X201 Inetl(R) Core(TM) i5 M560)
Mac OS(Macbook Pro Intel(R) Core(TM) i7 3520M)
2.Guest OS : Windows 2008 Server R2 X64 / Windows Server 2012
I have used Oracle Virtualbox to deploy lots of Windows Server with SQL Server 2012/2014 for stage usage. It could work perfectly with Microsoft product. But this time, It's the first time for me to encounter strange error message while I tried to create in-memory database.
CREATE DATABASE [Northwind_in_memory] CONTAINMENT = NONE
ON PRIMARY ( NAME = N'Northwind', FILENAME = N'c:\SQLdata\Nnorthwind.mdf' , SIZE = 4160KB
, MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ), FILEGROUP [hkNorthwind_mod]
CONTAINS MEMORY_OPTIMIZED_DATA DEFAULT ( NAME = N'Northwind_mod_dir', FILENAME = N'c:\SQLdata\Northwind_mod' ,
MAXSIZE = UNLIMITED) LOG ON ( NAME = N'Northwind_log', FILENAME = N'c:\SQLdata\Northwind_log.ldf' ,
SIZE = 4288KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
Here is the error message.
Msg 41342, Level 15, State 1, Line 7
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.
Regarding the information from the DMV of SQL Server 2014 and OS device manager,
The VM guest could successfully recognise those assigned CPU.
Is there any clue that I could find in order to solve this error message.