Export (0) Print
Expand All
Expand Minimize

sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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:
© 2015 Microsoft