Belešku
Pristup ovoj stranici zahteva autorizaciju. Možete pokušati da se prijavite ili da promenite direktorijume.
Pristup ovoj stranici zahteva autorizaciju. Možete pokušati da promenite direktorijume.
Applies to: 
SQL Server
Azure SQL Managed Instance
Removes residual information on data pages. sp_clean_db_free_space cleans all pages in all data files of the database.
Transact-SQL syntax conventions
Syntax
sp_clean_db_free_space
[ @dbname = ] N'dbname'
[ , [ @cleaning_delay = ] cleaning_delay ]
[ ; ]
Arguments
[ @dbname = ] N'dbname'
The name of the database to clean. @dbname is sysname, with no default.
[ @cleaning_delay = ] cleaning_delay
Specifies an interval to delay before the cleanup of each page, in seconds. @cleaning_delay is int, with a default of 0. This delay helps reduce the load on the I/O system at the expense of increasing the duration of the cleanup process.
Return code values
0 (success) or 1 (failure).
Remarks
The sp_clean_db_free_space system stored procedure moves all rows on a page, including the ghosted records if any, to the beginning of the page, and then zero-initializes the remainder of the data space on the page. In environments where the physical security of the data files or the underlying storage is at risk, you can use this stored procedure to ensure that no residual deleted data remains in the data files or in storage.
The time required to run sp_clean_db_free_space depends on the size of the data files, the number of used pages in the files, and the I/O capabilities of the disk. Because running sp_clean_db_free_space can significantly increase I/O activity, we recommend that you run this procedure outside the usual operation hours.
Before you run sp_clean_db_free_space, we recommend that you create a full database backup.
To perform this operation per database file, use sp_clean_db_file_free_space.
Permissions
Requires membership in the db_owner database role.
Examples
The following example cleans all residual data from the AdventureWorks2025 database.
USE master;
GO
EXECUTE sp_clean_db_free_space @dbname = N'AdventureWorks2022';