Blocking on something like Ghost Cleanup?

I noticed that several connections were blocked by something called Ghost Cleanup (or something like that). I know what the cleanup does, but it often causes blocking for quite a while . . .

Anything I can do about it? SS2000.

Thanks,

Michael

Did you check for error 602 in the error log? You want to make sure the object involved isn't damaged.

Other than that, being that they are created when row level locks are used for the delete, you can try using PAGLOCK or TABLOCK hints to avoid them being created.

-Sue