Return
-
Title
What are SQL Server ghosted records? -
Description
What are SQL Server ghosted records -
Resolution
Ghosted records - The rate at which SQL Server encounters Ghosted Records during scans. When a record is deleted from a table, SQL Server improves concurrency by not physically removing the row from index Leaf levels. Instead, the row is simply marked as deleted (ghosted).
At some later point, a housekeeping process asynchronously removes these rows from the leaf level.
Until the records are removed, SQL Server must skip the ghosted records during leaf-level scans.