Monday, February 28, 2011

Ghost clean up

Excellent post by Paul S Randall.
When a record is deleted from the table, SQL Server marks it as Ghost record which will be cleaned up when the background ghost clean job runs every 5 sec.

Thanks to Paul, he has just accepted my request to refer his post, Here is the link for his post.

http://www.sqlskills.com/blogs/paul/post/inside-the-storage-engine-ghost-cleanup-in-depth.aspx

No comments:

Post a Comment