Ghost Cleanup task in SQL Server
Posted by decipherinfosys on February 23, 2011
This topic of “Ghost Cleanup” background process came up while trying to resolve an issue at a client site recently. In case you have never heard of the ghost cleanup in SQL Server, here is an excellent post by MVP Paul Randal on this topic. And another post by him on the performance benefits of using a trace flag to turn it off in systems which have heavy delete workloads.