sys-sp-xtp-checkpoint-force-garbage-collection-transact-sql.md

title	sys.sp_xtp_checkpoint_force_garbage_collection (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/02/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.sp_xtp_checkpoint_force_garbage_collection_TSQL sys.sp_xtp_checkpoint_force_garbage_collection
dev_langs	TSQL
helpviewer_keywords	sys.sp_xtp_checkpoint_force_garbage_collection
ms.assetid	82b35b2b-edbd-44ac-9fc8-80695f2fd1df
author	stevestein
ms.author	sstein

sys.sp_xtp_checkpoint_force_garbage_collection (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2014-xxxx-xxxx-xxx-md]

Marks source files used in the merge operation with the log sequence number (LSN) after which they are not needed and can be garbage collected. Also, it moves the files whose associated LSN is lower than the log truncation point to filestream garbage collection.

Transact-SQL Syntax Conventions

Syntax

sys.sp_xtp_checkpoint_force_garbage_collection [[ @dbname=database_name]  

Arguments

database_name
The database to run garbage collection on. The default is the current database.

Return Code Values

0 for success. Nonzero for failure.

Result Set

A returned row contains the following information:

Column	Description
num_collected_items	Indicates the number of files that have been moved to filestream garbage collection. These are the files whose log sequence number (LSN) is less than the LSN of log truncation point
num_marked_for_collection_items	Indicates the number of data/delta files whose LSN has been updated with the log blockID of the end-of-log LSN.
last_collected_xact_seqno	Returns the last corresponding LSN up to which the files have been moved to filestream garbage collection.

Permissions

Requires database owner permission.

Sample

exec [sys].[sp_xtp_checkpoint_force_garbage_collection] hkdb1  

See Also

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