sys.sp_xtp_merge_checkpoint_files (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

sys.sp_xtp_merge_checkpoint_files (Transact-SQL)

 

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.

None

None

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.

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

Community Additions

ADD
Show:
© 2016 Microsoft