Link to home
Create AccountLog in
Avatar of KurtLinke
KurtLinke

asked on

SQL Server Ghost Cleanup Process is running continually

In tracing a production server(SQL Server 2000 on Windows Server 2003).  I see the ghost cleanup process running 100's of times a minute.  Is there any way of setting this task to run only when needed (after a delete)?  I do not want to turn off the process I just want it to run less frequently.

Thanks for any advice in advance
Kurt
ASKER CERTIFIED SOLUTION
Avatar of Mark Wills
Mark Wills
Flag of Australia image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Turning it off involves a something very nasty. Don't do it. Are you sure it is hundreds of times per minute ? How are you tracing ? Are there huge deletes ? are you set to auto-shrink ?