Hello
Does anyone know what this undocumented SP does?
the ghost cleanup task under normal circumstances runs every 5 seconds and cleans up 10r records per run.
It also runs continuously under two conditions:
1. The number of ghost records is above an unknown hard coded threshold
2. CPU utilisation is very low.
what does dbcc FORCEGHOSTCLEANUP do?
Does it obey the rulrs above and simply forces one 10 record run or does itrun continuously disregarding CPU utilisation and have to be killed to stop?
Thanks