Ghost Cleanup process has high CPU usage in SQL Server 2012 SP1
1
vote
0
answers
929
views
Has anyone encountered this? We are using SQL Server 2012 Enterprise Edition with SP1. During a time of low/no activity, I noticed the Ghost Cleanup process is utilizing CPU at a very high rate, from 75% to 99%, these aren't bursts but sustained usage.
I don't see the ghost cleanup process blocking itself, it just seems to take a lot of CPU while it runs, and never seems to complete. How can I tell if it's actually doing something?
Is this a bug with SQL Server 2012? I have seen this in SQL 2008 and there was a fix for it but I haven't seen anything for 2012.
Asked by kaitlyn
(593 rep)
Aug 16, 2013, 06:21 PM
Last activity: Feb 14, 2019, 08:42 PM
Last activity: Feb 14, 2019, 08:42 PM