Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

The Ghost Cleanup process is killing my server. I have tried everything and nothing seems to work:

  • Tried to run dbcc checkdb (didn't get any errors)
  • Tried rebuild indexes
  • tried to restart services and even the server

Please any help to show me how can I get rid of this mess... thanks!!!

share|improve this question

1 Answer 1

paul randal has written a few posts regarding the ghost process http://sqlskills.com/BLOGS/PAUL/search.aspx?q=ghost

he also talks about turning it off http://sqlskills.com/BLOGS/PAUL/post/Turning-off-the-ghost-cleanup-task-for-a-performance-gain.aspx

share|improve this answer
    
I have tried the rebuild index option, didn't work, I don't want to try option 611 because it's a production server –  Carlos Lone Mar 10 '10 at 19:12

Your Answer

 
discard

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