sys.sp_xtp_force_gc

general

#stored-procedure

Description

Causes the in-memory engine to release memory related to deleted rows of in-memory data that are eligible for garbage collection, which haven’t yet been released by the process. In cases where a large volume of in-memory data has been released, and where the memory isn’t soon be needed for other in-memory data, this procedure can free up memory for other uses.

Syntax

sys.sp_xtp_force_gc
[ [ @dbname = ]
'database_name'
]
[ ; ]

Examples

Example 1

sys.sp_xtp_force_gc

Example 2

@dbname = N'tempdb'

Example 3

@dbname =

Example 4

Example 5

sys.sp_xtp_force_gc

Example 6

sys.dm_xtp_system_memory_consumers

Example 7

sys.sp_xtp_checkpoint_force_garbage_collection

Example 8

EXECUTE sys.sp_xtp_force_gc N
'tempdb'
;
GO

Example 9

EXECUTE sys.sp_xtp_force_gc;
GO
EXECUTE sys.sp_xtp_force_gc N
'tempdb'
;
GO
EXECUTE sys.sp_xtp_force_gc N
'tempdb'
;
GO
EXECUTE sys.sp_xtp_force_gc;
GO
EXECUTE sys.sp_xtp_force_gc;
GO