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