Export (0) Print
Expand All
Expand Minimize

sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

SQL Server 2014

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

Applies to: SQL Server (SQL Server 2014 through current version).

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft