SQL Server Performance

DTSRUN.exe keeps running

Discussion in 'SQL Server DTS-Related Questions' started by georgej, Apr 5, 2007.

  1. georgej New Member

    On my SQL 2000 server I have SQL jobs to run DTS packages. Sometimes I need to cancel or stop the jobs before they completed. I find out that even the jobs are stopped or cancelled, their DTSrun.exe still keep running on the server. (I can check this from Task Manager). These multiple TDSrun.exe on the server cause the server performace very slow.
    Why does this happen? How can fix this problem?

    Thanks for assistance,

    George
  2. satya Moderator

    That is because the rollback on the process involved in that DTS package, do not attempt to cancel intermittently.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  3. georgej New Member

    Satya;

    Thanks for your reply.
    Since those DTSRUN.exe keep running on the server, making server performance very slow.
    So I kill those DTSRUN from Windows Task Manager.
    Does the killing action impact the data in my database?

    Georeg


    quote:Originally posted by satya

    That is because the rollback on the process involved in that DTS package, do not attempt to cancel intermittently.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page