Sample Header Ad - 728x90

GHOST_CLEANUP Lots of IO and CPU Usage

3 votes
2 answers
1895 views
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 usage (Real SQL Server Usage double checked with DMVs) and also a 20mb/s disk IO, this has been the same for 2 days now... I have found that the only process that is doing IO Operation is the ghost cleanup... After reviewing what data file is doing the IO Operation I found that I have 1500Reads/sec (NO WRITE OPERATIONS) on one Database where some users were doing load tests days ago... What can I do with this, will this process finish? Is there anything I can do?
Asked by J1mmy (550 rep)
Sep 27, 2016, 08:38 AM
Last activity: Aug 24, 2022, 06:38 AM