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.