Export (0) Print
Expand All

Transact-SQL Support for In-Memory OLTP

SQL Server 2014

The following Transact-SQL statements are modified to support In-Memory OLTP:

AUTO_UPDATE_STATISTICS is always OFF for memory-optimized tables. For more information, see sp_autostats (Transact-SQL).

Statistics on memory-optimized tables are always updated when executing sp_updatestats (Transact-SQL). Therefore, do not execute sp_updatestats more than necessary.

SET STATISTICS XML (Transact-SQL) ON is not supported for natively compiled stored procedures.

The modification_counter column in sys.dm_db_stats_properties (Transact-SQL) is not updated for memory-optimized tables.

Fiber mode (lightweight pooling Server Configuration Option) is not supported with memory-optimized tables:

  • If fiber mode is active, you cannot create databases with memory-optimized filegroups or add memory-optimized filegroups to existing databases.

  • You can enable fiber mode if there are databases with memory-optimized filegroups. However, enabling fiber mode requires a server restart. In that situation, databases with memory-optimized filegroups would fail to recover and you will see an error message suggesting that you disable fiber mode to use databases with memory-optimized filegroups.

  • Attaching and restoring databases with memory-optimized filegroups will fail if fiber mode is active. The databases will be marked as suspect.

For information on unsupported features, see Transact-SQL Constructs Not Supported by In-Memory OLTP.

For information about supported constructs in and on natively compiled stored procedures, see Supported Constructs in Natively Compiled Stored Procedures and Supported Constructs on Natively Compiled Stored Procedures.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft