Take the 2-minute tour ×
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.

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
add comment

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.