Export (0) Print
Expand All

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

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

sys.dm_db_xtp_checkpoint_stats (Transact-SQL)

sys.dm_db_xtp_checkpoint_files (Transact-SQL)

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:
© 2015 Microsoft