| title | sys.sp_xtp_merge_checkpoint_files (Transact-SQL) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 11/28/2016 | ||
| ms.prod | sql-non-specified | ||
| ms.reviewer | |||
| ms.suite | |||
| ms.technology |
|
||
| ms.tgt_pltfrm | |||
| ms.topic | language-reference | ||
| f1_keywords |
|
||
| dev_langs |
|
||
| helpviewer_keywords |
|
||
| ms.assetid | da04df2a-f7a1-41e7-a1ef-2d5d68919892 | ||
| caps.latest.revision | 15 | ||
| author | JennieHubbard | ||
| ms.author | jhubbard | ||
| manager | jhubbard |
[!INCLUDEtsql-appliesto-ss2014-xxxx-xxxx-xxx_md]
sys.sp_xtp_merge_checkpoint_files merges all data and delta files in the transaction range specified.
For more information, see Creating and Managing Storage for Memory-Optimized Objects.
Transact-SQL Syntax Conventions
| Note: This stored procedure is deprecated in [!INCLUDEssSQL15]. It is no longer needed, and cannot be used, starting [!INCLUDEssSQL15]. |
sys.sp_xtp_merge_checkpoint_files database_name, @transaction_lower_bound, @transaction_upper_bound
[;]
database_name
The name of the database on which to invoke the merge. If the database does not have in-memory tables, this procedure returns with user error. If the database is offline, it returns an error.
lower_bound_Tid
The (bigint) lower bound of transactions for a data file as shown in sys.dm_db_xtp_checkpoint_files (Transact-SQL) corresponding to the start checkpoint file of the merge. An error is generated for invalid transactonId value.
upper_bound_Tid
The (bigint) upper bound of transactions for a data file as shown in sys.dm_db_xtp_checkpoint_files (Transact-SQL). An error is generated for invalid transactonId value.
None
None
Requires sysadmin fixed server role and the db_owner fixed database role.
Merges all data and delta files in the valid range to produce a single data and delta file. This procedure does not honor the merge policy.
System Stored Procedures (Transact-SQL)
In-Memory OLTP (In-Memory Optimization)