sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

Applies to: SQL Server

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

Syntax

sys.sp_xtp_merge_checkpoint_files
    [ @database_name = ] database_name
    , [ @transaction_lower_bound = ] lower_bound_tid
    , [ @transaction_upper_bound = ] upper_bound_tid
[ ; ]

Arguments

[ @database_name = ] 'database_name'

The name of the database on which to invoke the merge. @database_name is sysname. If the database doesn't have in-memory tables, this procedure returns with user error. If the database is offline, it returns an error.

[ @transaction_lower_bound = ] 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 an invalid transaction ID.

[ @transaction_upper_bound = ] 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 an invalid transaction ID.

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 doesn't honor the merge policy.

Related content

• System stored procedures (Transact-SQL)
• In-Memory OLTP (In-Memory Optimization)