my understanding of the ghost cleanup process is that every five seconds it will look to removed ghosted records in an index. and so it will not overload the system, it will only "clean" roughly ten pages at a time.
so, that means it only cleans roughly 80k worth of records every five seconds? seems like my indexes would always be filled with ghosted records and the cleanup would never finish.
so, let's say i run a delete, perhaps a million rows, and the index records for those millions rows are roughly 8Gb in size. so roughly 100,000 times the difference of 80k. does that mean the ghost cleanup process will take 500,000s, or almost six days to complete?
clearly i am missing something here, because it does not make sense that it would take that long to clear out the ghosted records. and what about the other activity that hits that same index? does the ghost cleanup process cause waits, or have to wait for other processes?
[this question brought about by performance issues we have been seeing in the OpsMgrDW and we wanted to know more about this process]