sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2014)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

Topic link icon Transact-SQL Syntax Conventions

||
|-|
|Note: This stored procedure is deprecated in SQL Server 2016. It is no longer needed, and cannot be used, starting SQL Server 2016.|

Syntax


sys.sp_xtp_merge_checkpoint_files database_name, @transaction_lower_bound, @transaction_upper_bound  
[;]  

Arguments

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.

Return Code Values

None

Cursors Returned

None

Permissions

Requires sysadmin fixed server role and the db_owner fixed database role.

Remarks

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.

See Also

System Stored Procedures (Transact-SQL)
In-Memory OLTP (In-Memory Optimization)