Export (0) Print
Expand All

New and Updated Properties, System Views, Stored Procedures, Wait Types, and DMVs for In-Memory OLTP

SQL Server 2014

This topic lists the new and updated syntax to support memory-optimized tables.

New or updated property, system view, stored procedures, or DMV

Change

OBJECTPROPERTYEX (Transact-SQL)

ExecIsWithNativeCompilation and TableIsMemoryOptimized properties.

The IsSchemaBound property supports the Procedure object type (returns 0 for procedures instead of NULL).

SERVERPROPERTY (Transact-SQL)

IsXTPSupported property.

sys.data_spaces (Transact-SQL)

The following columns display additional values: type and type_desc.

sys.indexes (Transact-SQL)

The following columns display additional values: type and type_desc.

sys.parameters (Transact-SQL)

is_nullable column.

sys.all_sql_modules (Transact-SQL)

uses_native_compilation column.

sys.sql_modules (Transact-SQL)

uses_native_compilation column.

sys.table_types (Transact-SQL)

is_memory_optimized column.

sys.tables (Transact-SQL)

durability, durability_desc, and is_memory_optimized columns.

sys.hash_indexes (Transact-SQL)

System view.

sys.sp_xtp_bind_db_resource_pool (Transact-SQL)

Stored procedure.

sys.sp_xtp_checkpoint_force_garbage_collection (Transact-SQL)

Stored procedure.

sys.sp_xtp_control_proc_exec_stats (Transact-SQL)

Stored procedure.

sys.sp_xtp_control_query_exec_stats (Transact-SQL)

Stored procedure.

sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

Stored procedure.

sys.sp_xtp_unbind_db_resource_pool (Transact-SQL)

Stored procedure.

Memory-Optimized Table Dynamic Management Views (Transact-SQL)

DMVs to support In-Memory OLTP.

The following wait types are added to support In-Memory OLTP:

  • WAIT_XTP_CKPT_CLOSE

  • WAIT_XTP_CKPT_ENABLED

  • WAIT_XTP_CKPT_STATE_LOCK

  • WAIT_XTP_GUEST

  • WAIT_XTP_HOST_WAIT

  • WAIT_XTP_OFFLINE_CKPT_LOG_IO

  • WAIT_XTP_OFFLINE_CKPT_NEW_LOG

  • WAIT_XTP_PROCEDURE_ENTRY

  • WAIT_XTP_TASK_SHUTDOWN

  • WAIT_XTP_TRAN_COMMIT

  • WAIT_XTP_TRAN_DEPENDENCY

  • XTPPROC_CACHE_ACCESS

  • XTPPROC_PARTITIONED_STACK_CREATE

For more information, about these wait types, see sys.dm_os_wait_stats (Transact-SQL).

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

Community Additions

ADD
Show:
© 2014 Microsoft