{"id":1158,"date":"2007-10-08T16:24:00","date_gmt":"2007-10-08T16:24:00","guid":{"rendered":"\/blogs\/paul\/post\/Inside-the-Storage-Engine-Ghost-cleanup-in-depth.aspx"},"modified":"2017-04-13T09:52:07","modified_gmt":"2017-04-13T16:52:07","slug":"inside-the-storage-engine-ghost-cleanup-in-depth","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/","title":{"rendered":"Inside the Storage Engine: Ghost cleanup in depth"},"content":{"rendered":"

<\/p>\n

\nOver the years I was in the Storage Engine team I saw a lot of concern on the various forums about the ghost cleanup task. There have been a few bugs with it in previous versions  (see these KB articles – 932115<\/a> and 815594<\/a>) and there's very little info available on it. For some reason I didn't get around to posting about it on my old blog but today I want to go into some depth on it.\n<\/p>\n

\nSo what is ghost cleanup? It's a background process that cleans up ghost records – usually referred to as the ghost cleanup task. What's a ghost record? As I described briefly in the Anatomy of a record post<\/a> last week, a ghost record is one that's just been deleted in an index on a table<\/em> (well, actually it gets more complicated if snapshot isolation of some form is enabled but for now, a record in an index is a good start). Such a delete operation never physically removes records from pages – it only marks them as having been deleted, or ghosted. This is a performance optimization that allows delete operations to complete more quickly. It also allows delete operations to rollback more quickly because all that needs to happen is to unmark the records as being deleted\/ghosted, instead of having to reinsert the deleted records. The deleted record will be physically removed (well, its slot will be removed – the record data isn't actually overwritten) later by the background ghost cleanup task. The ghost cleanup task will leave a single record on the page to avoid having to deallocate empty data or index pages.\n<\/p>\n

\nThe ghost cleanup task can't physically delete the ghost records until after the delete transaction commits because the deleted records are locked and the locks aren't released until the transaction commits. As an aside, when ghost records exist on a page, even a NOLOCK or READ UNCOMMITTED scan won't return them because they are marked as ghost records.\n<\/p>\n

\nWhen a record is deleted, apart from it being marked as a ghost record, the page that the record is on is also marked as having ghost records in one of the allocation maps – the PFS page (post coming soon!) – and in its page header. Marking a page as having ghost records in a PFS page also changes the database state to indicate that there are some ghost records to cleanup – somewhere. Nothing tells the ghost cleanup task to clean the specific page that the delete happened on – yet. That only happens when the next scan operation reads the page and notices that the page has ghost records.\n<\/p>\n

\nThe ghost cleanup task doesn't just start up when it's told to – it starts up in the background every 5 seconds and looks for ghost records to cleanup. Remember that it won't be told to go cleanup a specific<\/em> page by a delete operation – it's a subsequent scan that does it, if a scan happens. When the ghost cleanup task starts up it checks to see if its been told to cleanup a page – if so it goes and does it. If not, it picks the next database that is marked as having some ghost records and looks through the PFS allocation map pages to see if there are any ghost records to cleanup. It will check through or cleanup a limited number of pages each time it wakes up – I remember the limit is 10 pages – to ensure it doesn't swamp the system. So – the ghost records will eventually be removed – either by the ghost cleanup task processing a database for ghost records or by it specifically being told to remove them from a page. If it processes a database and doesn't find any ghost records, it marks the database as not having any ghost records so it will be skipped next time.\n<\/p>\n

\nHow can you tell its running? On SQL Server 2005, you can use the following code to see the ghost cleanup task in sys.dm_exec_requests<\/font>:\n<\/p>\n

\n\t<\/p>\n

\n\tSELECT<\/font> <\/font>*<\/font> <\/font>INTO<\/font> myexecrequests <\/font>FROM<\/font> <\/font>sys.dm_exec_requests<\/font> <\/font>WHERE<\/font> 1 <\/font>= <\/font>0<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tSET<\/font> <\/font>NOCOUNT<\/font> <\/font>ON<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font>DECLARE<\/font><\/font> @a <\/font>INT<\/font><\/font> <\/p>\n

\n\tSELECT<\/font> @a <\/font>=<\/font> 0<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tWHILE<\/font> <\/font>(<\/font>@a <\/font><<\/font> 1<\/font>)<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tBEGIN\n\t<\/p>\n

\t<\/font><\/p>\n

\n

\n\t\tINSERT<\/font> <\/font>INTO<\/font> myexecrequests <\/font>SELECT<\/font> <\/font>*<\/font> <\/font>FROM<\/font> <\/font>sys.dm_exec_requests<\/font> <\/font>WHERE<\/font> command <\/font>LIKE<\/font> <\/font>'%ghost%'<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/p>\n

\n\t\tSELECT<\/font> @a <\/font>=<\/font> <\/font>COUNT<\/font> <\/font>(*)<\/font> <\/font>FROM<\/font> myexecrequests<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font>\n\t<\/p><\/blockquote>\n

\t<\/font><\/p>\n

\n\tEND<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tSELECT<\/font> <\/font>*<\/font> <\/font>FROM<\/font> myexecrequests<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\n\tAnd on SQL Server 2000 you need to use sysprocesses<\/font> (well, on SQL Server 2005 this works as well but its fake view derived from the DMVs):<\/font>\n\t<\/p>\n

\n\t\t<\/p>\n

\n\t\tSELECT<\/font> <\/font>*<\/font> <\/font>INTO<\/font> mysysprocesses <\/font>FROM<\/font> master<\/font>.<\/font>dbo<\/font>.<\/font>sysprocesses <\/font>WHERE<\/font> 1 <\/font>=<\/font> 0<\/font>;<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tSET<\/font> <\/font>NOCOUNT<\/font> <\/font>ON<\/font>;<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font>DECLARE<\/font><\/font> @a <\/font>INT<\/font><\/font><\/font> <\/p>\n

\n\t\tSELECT<\/font> @a <\/font>=<\/font> 0<\/font>;<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tWHILE<\/font> <\/font>(<\/font>@a <\/font><<\/font> 1<\/font>)<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tBEGIN\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n

\n\t\t\tINSERT<\/font> <\/font>INTO<\/font> mysysprocesses <\/font>SELECT<\/font> <\/font>*<\/font> <\/font>FROM<\/font> master<\/font>.<\/font>dbo<\/font>.<\/font>sysprocesses <\/font>WHERE<\/font> cmd <\/font>LIKE<\/font> <\/font>'%ghost%'<\/font><\/font>\n\t\t\t<\/p>\n

\t\t\t<\/p>\n

\n\t\t\tSELECT<\/font> @a <\/font>=<\/font> <\/font>COUNT<\/font> <\/font>(*)<\/font> <\/font>FROM<\/font> mysysprocesses<\/font><\/font>\n\t\t\t<\/p>\n

\t\t\t<\/font>\n\t\t<\/p><\/blockquote>\n

\t\t<\/font><\/p>\n

\n\t\tEND<\/font>;<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tSELECT<\/font> <\/font>*<\/font> <\/font>FROM<\/font> mysysprocesses<\/font>;<\/font><\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font>\n\t<\/p><\/blockquote>\n

\t<\/font>\n<\/p><\/blockquote>\n

<\/font><\/p>\n

\nThe output from sys.dm_exec_requests<\/font> is (with most unused and uninteresting columns stripped off):<\/font>\n<\/p>\n

\n

\n\tsession_id request_id  start_time              status       command
\n\t———- ———– ———————– ———— —————-
\n\t15         0           2007-10-05 16:34:49.653 background   GHOST CLEANUP\n\t<\/p>\n<\/blockquote>\n

\nSo how can you tell if a record is ghosted? Let's engineer some and look at it with DBCC PAGE<\/font><\/font> – I've stripped out the uninteresting bits of the output and highlighted the interesting ghost parts:<\/font>\n<\/p>\n

\n\t<\/p>\n

\n\tCREATE<\/font> <\/font>TABLE<\/font> t1 <\/font>(<\/font>c1 <\/font>CHAR<\/font>(<\/font>10<\/font>))<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tCREATE<\/font> <\/font>CLUSTERED<\/font> <\/font>INDEX<\/font> t1c1 <\/font>on<\/font> t1 <\/font>(<\/font>c1<\/font>)<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font>BEGIN<\/font><\/font> <\/font>TRAN<\/font><\/font><\/font> <\/p>\n

\n\tINSERT<\/font> <\/font>INTO<\/font> t1 <\/font>VALUES<\/font> <\/font>(<\/font>'PAUL'<\/font>)<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tINSERT<\/font> <\/font>INTO<\/font> t1 <\/font>VALUES<\/font> <\/font>(<\/font>'KIMBERLY'<\/font>)<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tDELETE<\/font> <\/font>FROM<\/font> t1 WHERE<\/font> c1<\/font>=<\/font>'KIMBERLY'<\/font><\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tDBCC<\/font> IND <\/font>(<\/font>'ghostrecordtest'<\/font>,<\/font> <\/font>'t1'<\/font>,<\/font> 1<\/font>);<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tDBCC<\/font> TRACEON <\/font>(<\/font>3604<\/font>);<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tDBCC<\/font> PAGE <\/font>(<\/font>'ghostrecordtest'<\/font>,<\/font> 1<\/font>,<\/font> 143<\/font>,<\/font> 3<\/font>);<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO\n\t<\/p>\n

\n\t<snip>\n\t<\/p>\n

\n\tm_freeData = 130    m_reservedCnt = 0   m_lsn = (20:88:20)
\n\tm_xactReserved = 0  m_xdesId = (0:518)  m_ghostRecCnt = 1<\/strong>
\n\tm_tornBits = 0\n\t<\/p>\n

\n\t<snip>\n\t<\/p>\n

\n\tSlot 0 Offset 0x71 Length 17\n\t<\/p>\n

\n\tRecord Type = GHOST_DATA_RECORD<\/strong>      Record Attributes =  NULL_BITMAP
\n\tMemory Dump @0x6256C071\n\t<\/p>\n

\n\t00000000:   1c000e00 4b494d42 45524c59 20200200 †….KIMBERLY  ..
\n\t00000010:   fc†††††††††††††††††††††††††††††††††††.
\n\tUNIQUIFIER = [NULL]\n\t<\/p>\n

\n\tSlot 0 Column 1 Offset 0x4 Length 10\n\t<\/p>\n

\n\tc1 = KIMBERLY\n\t<\/p>\n

\n\tSlot 1 Offset 0x60 Length 17\n\t<\/p>\n

\n\tRecord Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
\n\tMemory Dump @0x6256C060\n\t<\/p>\n

\n\t00000000:   10000e00 5041554c 20202020 20200200 †….PAUL      ..
\n\t00000010:   fc†††††††††††††††††††††††††††††††††††.
\n\tUNIQUIFIER = [NULL]\n\t<\/p>\n

\n\tSlot 1 Column 1 Offset 0x4 Length 10\n\t<\/p>\n

\n\tc1 = PAUL<\/font><\/font>\n\t<\/p>\n

\t<\/font>\n<\/p><\/blockquote>\n

<\/font><\/p>\n

\nLet's see what goes on the transaction log during this process (remember this is undocumented and unsupported – do it on a test database) – I've stripped off a bunch of the columns in the output:\n<\/p>\n

\n\t<\/p>\n

\n\tDECLARE<\/font> @a <\/font>CHAR<\/font> <\/font>(<\/font>20<\/font>)<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tSELECT<\/font> @a <\/font>=<\/font> [Transaction ID] <\/font>FROM<\/font> fn_dblog <\/font>(null,<\/font> <\/font>null)<\/font> <\/font>WHERE<\/font> [Transaction Name]<\/font>=<\/font>'PaulsTran'<\/font><\/font>\n\t<\/p>\n

\t<\/font>SELECT<\/font><\/font> <\/font>*<\/font> <\/font>FROM<\/font> fn_dblog <\/font>(null,<\/font> <\/font>null)<\/font> <\/font>WHERE<\/font> [Transaction ID] <\/font>=<\/font> @a;<\/font><\/font><\/font><\/font><\/font> <\/p>\n

\n\tGO\n\t<\/p>\n

\t<\/font><\/font><\/font><\/font><\/p>\n

\n\tCurrent LSN              Operation         Context             Transaction ID
\n\t———————— —————– ——————- ————–
\n\t00000014:00000054:0011   LOP_BEGIN_XACT    LCX_NULL            0000:00000206
\n\t00000014:0000005a:0012   LOP_INSERT_ROWS   LCX_CLUSTERED       0000:00000206
\n\t00000014:0000005a:0013   LOP_INSERT_ROWS   LCX_CLUSTERED       0000:00000206
\n\t00000014:0000005a:0014   LOP_DELETE_ROWS   LCX_MARK_AS_GHOST   0000:00000206
\n\t00000014:0000005a:0016   LOP_DELETE_ROWS   LCX_MARK_AS_GHOST   0000:00000206<\/font><\/font><\/font>\n\t<\/p>\n<\/blockquote>\n

<\/font><\/p>\n

\nSo there are the two inserts followed by the two deletes – with the rows being marked as ghost records. But where's the update to the PFS page? Well, changing the ghost bit in a PFS page is not done as part of a transaction. We'll need to look for it another way (apart from just dumping everything in the transaction log and searching manually):<\/font><\/font><\/font>\n<\/p>\n

\n\t<\/p>\n

\n\tSELECT<\/font> <\/font>Description<\/font>,<\/font> <\/font>*<\/font> <\/font>FROM<\/font> fn_dblog <\/font>(null,<\/font> <\/font>null)<\/font> <\/font>WHERE<\/font> Context <\/font>like<\/font> <\/font>'%PFS%'<\/font> <\/font>AND<\/font> AllocUnitName <\/font>like<\/font> <\/font>'%t1%'<\/font>;<\/font><\/font>\n\t<\/p>\n

\t<\/font><\/p>\n

\n\tGO<\/font>\n\t<\/p>\n

\n\tDescription               Current LSN              Operation        Context   Transaction ID
\n\t————————- ———————— —————- ——— —————-
\n\tAllocated 0001:0000008f   00000014:00000054:0014   LOP_MODIFY_ROW   LCX_PFS   0000:00000208
\n\t                          00000014:0000005a:0015   LOP_SET_BITS     LCX_PFS   0000:00000000<\/font>\n\t<\/p>\n

\n\tThe first one is just allocating a page but the second one is the one we're looking for – it's changed the bit for the page to say it has ghost records on. Let's commit the transaction and see what happens, filtering out all the previous transaction log:\n\t<\/p>\n

\n\t\t<\/p>\n

\n\t\tSELECT <\/font>MAX<\/font> <\/font>(<\/font>[Current LSN]<\/font>)<\/font> <\/font>FROM<\/font> fn_dblog <\/font>(null,<\/font> <\/font>null);<\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\t— 00000014:0000005e:0001\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tCOMMIT <\/font>TRAN<\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tSELECT [Page ID]<\/font>,<\/font> <\/font><\/font>*<\/font> <\/font>FROM<\/font> fn_dblog <\/font>(null,<\/font> <\/font>null)<\/font> <\/font>WHERE<\/font> [Current LSN] <\/font>><\/font> <\/font>'00000014:0000005e:0001'<\/font>;<\/font>\n\t\t<\/p>\n

\t\t<\/font><\/p>\n

\n\t\tGO\n\t\t<\/p>\n

\n\t\tPage ID         Current LSN              Operation          Context         Transaction ID
\n\t\t————— ———————— —————— ————— ————–
\n\t\tNULL            00000014:0000005f:0001   LOP_COMMIT_XACT    LCX_NULL        0000:00000206
\n\t\t0001:0000008f   00000014:00000060:0001   LOP_EXPUNGE_ROWS   LCX_CLUSTERED   0000:00000000<\/font>\n\t\t<\/p>\n

\n\t\tWe see that almost as soon as the transaction has commited, the ghost cleanup task goes in and process the page. Let's check a page dump to make sure the record is gone, and show that the contents of the record are still on the page (again, with non-relevant bits snipped out):\n\t\t<\/p>\n

\n\t\t\t<\/p>\n

\n\t\t\tDBCC<\/font> PAGE <\/font>(<\/font>'ghostrecordtest'<\/font>,<\/font> 1<\/font>,<\/font> 143<\/font>,<\/font> 3<\/font>);<\/font><\/font>\n\t\t\t<\/p>\n

\t\t\t<\/font><\/p>\n

\n\t\t\tGO\n\t\t\t<\/p>\n

\n\t\t\t<snip>\n\t\t\t<\/p>\n

\n\t\t\tm_freeData = 130         m_reservedCnt = 0        m_lsn = (20:94:1)
\n\t\t\tm_xactReserved = 0       m_xdesId = (0:518)       m_ghostRecCnt = 0<\/strong>
\n\t\t\tm_tornBits = 0\n\t\t\t<\/p>\n

\n\t\t\t<snip>\n\t\t\t<\/p>\n

\n\t\t\tRecord Type = PRIMARY_RECORD         Record Attributes =  NULL_BITMAP
\n\t\t\tMemory Dump @0x6212C060\n\t\t\t<\/p>\n

\n\t\t\t00000000:   10000e00 5041554c 20202020 20200200 †….PAUL      ..
\n\t\t\t00000010:   fc†††††††††††††††††††††††††††††††††††.
\n\t\t\tUNIQUIFIER = [NULL]\n\t\t\t<\/p>\n

\n\t\t\tSlot 0 Column 1 Offset 0x4 Length 10\n\t\t\t<\/p>\n

\n\t\t\tc1 = PAUL\n\t\t\t<\/p>\n

\t\t\t<\/p>\n

\n\t\t\tDBCC PAGE <\/font>(<\/font>'ghostrecordtest'<\/font>,<\/font> 1<\/font>,<\/font> 143<\/font>,<\/font> 2<\/font>);<\/font>\n\t\t\t<\/p>\n

\t\t\t<\/font><\/p>\n

\n\t\t\tGO\n\t\t\t<\/p>\n

\t\t\t<\/font><\/p>\n

\n\t\t\t<snip>\n\t\t\t<\/p>\n

\n\t\t\t6212C040:   01000000 00000000 00000000 00000000 †…………….
\n\t\t\t6212C050:   00000000 00000000 00000000 00000000 †…………….
\n\t\t\t6212C060:   10000e00 5041554c 20202020 20200200 †….PAUL      ..
\n\t\t\t6212C070:   fc1c000e 004b494d 4245524c 59202002 †…..KIMBERLY<\/strong>  .
\n\t\t\t6212C080:   00fc0000 00000000 00000000 01000000 †…………….
\n\t\t\t6212C090:   00000000 13000000 01000000 00000000 †…………….\n\t\t\t<\/p>\n

\n\t\t\t<snip>\n\t\t\t<\/p>\n

\t\t\t<\/font>\n\t\t<\/p><\/blockquote>\n

\n\t\tSo even though the record no longer exists, all that happened was that the slot was removed from the slot array at the end of the page – the record contents will remain on the page until the space is reused.\n\t\t<\/p>\n

\n\t\tIn the next post I'll go into details of the PFS and other allocation maps. Btw – please let me know if this stuff is interesting – I'd like to know where to spend blogging time. Thanks!\n\t\t<\/p>\n

\t\t<\/font>\n\t<\/p><\/blockquote>\n

\t<\/font><\/font><\/font><\/font>\n<\/p><\/blockquote>\n

<\/font><\/p>\n","protected":false},"excerpt":{"rendered":"

Over the years I was in the Storage Engine team I saw a lot of concern on the various forums about the ghost cleanup task. There have been a few bugs with it in previous versions  (see these KB articles – 932115 and 815594) and there's very little info available on it. For some reason […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38,48,62,98,100],"tags":[],"class_list":["post-1158","post","type-post","status-publish","format-standard","hentry","category-example-scripts","category-inside-the-storage-engine","category-on-disk-structures","category-transaction-log","category-undocumented-commands"],"yoast_head":"\nInside the Storage Engine: Ghost cleanup in depth - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Inside the Storage Engine: Ghost cleanup in depth - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"Over the years I was in the Storage Engine team I saw a lot of concern on the various forums about the ghost cleanup task. There have been a few bugs with it in previous versions  (see these KB articles – 932115 and 815594) and there's very little info available on it. For some reason […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2007-10-08T16:24:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-13T16:52:07+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/\",\"name\":\"Inside the Storage Engine: Ghost cleanup in depth - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2007-10-08T16:24:00+00:00\",\"dateModified\":\"2017-04-13T16:52:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Inside the Storage Engine: Ghost cleanup in depth\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Inside the Storage Engine: Ghost cleanup in depth - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/","og_locale":"en_US","og_type":"article","og_title":"Inside the Storage Engine: Ghost cleanup in depth - Paul S. Randal","og_description":"Over the years I was in the Storage Engine team I saw a lot of concern on the various forums about the ghost cleanup task. There have been a few bugs with it in previous versions  (see these KB articles – 932115 and 815594) and there's very little info available on it. For some reason […]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/","og_site_name":"Paul S. Randal","article_published_time":"2007-10-08T16:24:00+00:00","article_modified_time":"2017-04-13T16:52:07+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/","name":"Inside the Storage Engine: Ghost cleanup in depth - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2007-10-08T16:24:00+00:00","dateModified":"2017-04-13T16:52:07+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/inside-the-storage-engine-ghost-cleanup-in-depth\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"Inside the Storage Engine: Ghost cleanup in depth"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=1158"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/1158\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=1158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=1158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=1158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}