Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 DTExec.exe using 100% CPU

Author  Topic 

king303
Starting Member

2 Posts

Posted - 2008-07-15 : 04:31:09
Hello,

we are using the following version of sqlserver 2005, DTExec.exe process is using 100% CPU. please let me know if anyone has faced this problem.

=========================================================
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
==========================================================

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-15 : 05:22:37
Is it currently running?
http://msdn.microsoft.com/en-us/library/ms162810.aspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

king303
Starting Member

2 Posts

Posted - 2008-07-15 : 05:31:01
Thanks Peso,

yes its still running and using 100% CPU, we use peoplesoft application and just use query analyzer only.

can we kill this process - if yes, what could be the implications...this is not a PROD env, but we use it for other purpose.

Thanks.
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-15 : 23:16:31
Any package running? If not, you can stop ssis service.
Go to Top of Page
   

- Advertisement -