Post reply

GHost clean up sysstem task

  • December 16, 2002 at 12:44 pm

    #159309

    Can some one through some light on the sysstem tasks which runns the command Ghost clean up.

    Thanks

  • December 16, 2002 at 12:52 pm

    #444517

    removal of temp objects, cursors, sort or hash tables, will all cause these clean up tasks to occur. What are you trying to determine? Do you have a high occurance of these and want to reduce the amount? Are you just curious?

  • December 16, 2002 at 1:07 pm

    #444522

    Hi,

    I am curious to know whether it slows the server performance.Since one of my databases has a pocess running this command against a database since 3 days and i see that all the process running against this table are very slow.

    Any input on this is highly appreciated.

    Thanks

  • December 16, 2002 at 1:08 pm

    #444523

    I mean the database not table.

    Thanks

  • December 16, 2002 at 1:20 pm

    #444526

    Look at the start time and last batch time. Are you certain that the same process has been running for three days? That doesn't sound like clean ups I'm used to. If its a lot of cleanup jobs hitting back to back due to object creation and deletion, I could understand it, but three days is way way too long for any cleanup by GHOST that I've ever seen.

    As for the performance hits, absolutely. The cleanup involves disk IO and processing time, and that will naturally impact your database, though to what extent I couldn't say. Too many variables without looking at some performance numbers. Most of the ones I see in my databases have a very small impact

  • March 21, 2003 at 7:39 am

    #451682

    I've just noticed the Ghost Cleanup process running against my production database; however, it was not running for very long. Reading this thread has helped me to not worry! Deleting two thirds of a million-row table one row at a time probably caused it...

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply