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
Last activity: Aug 24, 2022, 06:38 AM