Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sunny Parallel Processing RE: Parallel Processing

  • October 12, 2009 at 7:06 am

    #1064702

    Kevin.McEvoy (10/12/2009)

    Really interesting article.

    Could the clean up process use something like sp_who to find out if a process was currently running or orphaned. I'm always a bit dubious about things that depend on timings which would need to be tuned for each installation depending upon resources, data sizes etc.

    Thanks Kevin. Yes I too tried digging into any such readily available command which could tell whether the process is currently active. Hope to get more leads in this forum. The UPDATE..OUTPUT statement suggested by Simon appears to be very helpful. Thanks Simon 🙂

    Thanks

    Satish