Questions tagged [ghost-cleanup]

The SQL Server ghost cleanup task is responsible for removing data logically marked as deleted, but not yet physically removed from the target data structure.

Filter by
Sorted by
Tagged with
3
votes
2answers
608 views

GHOST_CLEANUP Lots of IO and CPU Usage

I have been trying to troubleshoot an issue I have detected on a UAT SQL Server, there is some resource usage even if the server is not being used... On Activity monitor I have an average of 5% CPU ...