New and Updated Properties, System Views, Stored Procedures, Wait Types, and DMVs for In-Memory OLTP
Applies To: Azure SQL Database, SQL Server 2016 Preview
This topic lists properties, system views, columns in system views, and wait types to support In-Memory OLTP.
New or updated property, system view, stored procedures, or DMV |
Change |
|---|---|
ExecIsWithNativeCompilation and TableIsMemoryOptimized properties. The IsSchemaBound property supports the Procedure object type (returns 0 for procedures instead of NULL). |
|
IsXTPSupported property. |
|
The following columns display additional values: type and type_desc. |
|
The following columns display additional values: type and type_desc. |
|
is_nullable column. |
|
uses_native_compilation column. |
|
uses_native_compilation column. |
|
is_memory_optimized column. |
|
durability, durability_desc, and is_memory_optimized columns. |
|
System view. |
|
Stored procedure. |
|
sys.sp_xtp_checkpoint_force_garbage_collection (Transact-SQL) |
Stored procedure. |
Stored procedure. |
|
Stored procedure. |
|
Stored procedure. |
|
Stored procedure. |
|
Memory-Optimized Table Dynamic Management Views (Transact-SQL) |
DMVs to support In-Memory OLTP. |
Wait Types
The following wait types 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).