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.
|Applies to: SQL Server (SQL Server 2014 through current version).|
sys.sp_xtp_merge_checkpoint_files database_name, @transaction_lower_bound, @transaction_upper_bound [;]
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.
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.
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.
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.