Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

Is this a bug with SQL 2012? I have seen this in SQL 2008 R2 and there was a fix for it but I haven't seen anything for 2012.

share|improve this question
    
    
That connect item was closed as won't fix. Where do you see a fix for 2008 R2? – Aaron Bertrand Aug 16 '13 at 18:23
    
Sorry, the fix was actually for SQL 2008 not SQL 2008 R2. support.microsoft.com/kb/978430. So this issue still happens in SQL 2008R2 and SQL 2012? There's no workaround or fix? – kaitlyn Aug 16 '13 at 20:39
    
I looked into this and I believe this might still be a bug in 2012. If the GHOST CLEANUP process shows as blocking itself in sp_who2 or sys.dm_exec_requests, call Microsoft PSS. – Aaron Bertrand Aug 17 '13 at 19:37
    
I don't see the GHOST CLEANUP process blocking itself, it just seem to take alot of CPU while it runs and never seems to complete. How can I tell if it's actually doing something? – kaitlyn Aug 19 '13 at 16:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.