Lorsque j’ai voulu créer une table In-Memory dans SQL Server 2014 CTP2, dans une machine virtuelle virtualBox, j’ai obetnu la message d’erreur suivant de la part de SQL Server :
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.
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.
J’ai trouvé la réponse ici : mattsql.wordpress.com/2013/07/08/in-memory-oltp-with-sql-server-2014/
qui est: lancer ceci en ligne de commande :
VBoxManage setextradata [vmname] VBoxInternal/CPUM/CMPXCHG16B 1
et redémarrer la machine virtuelle.