Systems Engineering and RDBMS

Ghost Cleanup task in SQL Server

Posted by decipherinfosys on February 23, 2011

This topic of “Ghost Cleanup” background process came up while trying to resolve an issue at a client site recently.  In case you have never heard of the ghost cleanup in SQL Server, here is an excellent post by MVP Paul Randal on this topic.  And another post by him on the performance benefits of using a trace flag to turn it off in systems which have heavy delete workloads.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: