DTS Hanging

Question

DTS Hanging

ebinroy

Mr or Mrs. 500

Points: 548
More actions
December 9, 2007 at 8:01 pm

#70549

Hi,
DTS is hanging while execting.This DTS run in every one minute.Normally DTS Complete in one second.Hanging once in a month(not every month).We are having 10 servers.Every server having this DTS.I dont know whats the problem.Please help.How to avoid this.Is there any method to stop the DTS if it executes more than 1 minutes.Please help.Thanks in Advance.
With Regards,
Leo

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

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

michaela SSCertifiable Points: 5649 More actions · Answer 1

"Hanging" could have many meanings; it looks like your DTS process(es) is blocked by something else. If this happens every day at the same time then you may check for jobs that are running transactions over the same table(s) as you DTS. If you know you have heavy selects over the same db then it's good to check the db isolation level - check for blockings between reders/writers. Use db_who to see what's running when you get this "hanging".

Good luck

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 2

I think you mean sp_who.

What does the DTS package do? More information would help.

ebinroy Mr or Mrs. 500 Points: 548 More actions · Answer 3

hi sir,

Thanks for the immediate reply.The DTS is updating the local Database's table few fields data.Actually upating the current reservation status.I give the owner as 'sa' ,It is not hanging regularly,once in a month or 2 month gap.Thanks

Steve Jones - SSC Editor SSC Guru Points: 736255 More actions · Answer 4

How is it updating? Is it doing a transformation? Is it an Execute SQL task? You haven't really explained how it works.

If it's just using SQL, why not use a job instead of a package?

Have you enabled logging for the package?