troubleshooting Question

SQL Server Ghost Cleanup Process is running continually

Avatar of KurtLinke
KurtLinke asked on
Microsoft SQL Server
2 Comments1 Solution1043 ViewsLast Modified:
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
Mark Wills
Topic Advisor
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros