[Company Logo Image] 

Home Up Contents Coffee Break Credits Links Search

Ghost Record Cleanup



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Ghost Record Cleanup Process

When rows are deleted from an index leaf page, the space is not released immediately, instead SQL Server marks those records as "ghost records" (records pending for deletion).  Later the Ghost Record Cleanup Process will remove those records physically in an asynchronous fashion, improving the performance of the delete operations.

The Ghost Record Cleanup Process has also an impact on the insert operation.  SQL Server allocates new pages when there is no room for data in the existing pages. They incur in pages split, moving 50% of the rows form the filled up pages to the newly allocated pages.  SQL Server mark the records moved from the filled pages as "ghost records", which are later removed by the Ghost Record Cleanup Process. 








.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.