sys.sp_clean_db_file_free_space
general #stored-procedure
Description
Removes residual information on data pages. cleans all pages in only one file of a database.
Syntax
sp_clean_db_file_free_space
Remarks
Removes residual information on data pages.
cleans all pages in
only one file of a database.
The name of the database to clean.
, with no default.
The data file ID to clean.
, with no default.
Specifies an interval to delay before the cleanup of each page, in seconds.
@cleaning_delay
, with a default of. This delay helps reduce the load on the I/O system at the expense of
increasing the duration of the cleanup process.
(success) or
Examples
Example 1
sp_clean_db_file_free_space
Example 2
sp_clean_db_file_free_space
Example 3
sp_clean_db_file_free_space
Example 4
sp_clean_db_file_free_space
Example 5
AdventureWorks2025
Example 6
USE master
;
GO
EXECUTE sp_clean_db_file_free_space
@dbname = N
'AdventureWorks2022'
,
@fileid = 1;