| Author |
Monitoring DTS Execution
|
|
| Cqlboy 2006-03-29, 3:28 am |
| How do I identify running DTS executions? We have some DTS's which don't log
to the system (DTS) tables and are absolute resource dogs !!! So, how do I
identify them? All I can get from master..sysprocesses is "DTS Designer" and
the enormous I/O being generated.
Thanx.
-Cqlboy
| |
| Satya SKJ 2006-03-29, 7:31 am |
| If you 've defined proper workflow and enabled the DTS package log then it
should write the information. Also run PERFMON during this operation to
further investigation.
--
-----------------
Satya SKJ
Visit http://www.sql-server-performance.com for tips and articles on
Performance topic.
"Cqlboy" wrote:
> How do I identify running DTS executions? We have some DTS's which don't log
> to the system (DTS) tables and are absolute resource dogs !!! So, how do I
> identify them? All I can get from master..sysprocesses is "DTS Designer" and
> the enormous I/O being generated.
>
> Thanx.
>
> -Cqlboy
| |
| Cqlboy 2006-03-29, 8:27 pm |
| Thanks, Satya. I've seen your replies many times - good stuff !
I will look more closely.
-Cqlboy
"Satya SKJ" wrote:
[color=darkred]
> If you 've defined proper workflow and enabled the DTS package log then it
> should write the information. Also run PERFMON during this operation to
> further investigation.
> --
> -----------------
> Satya SKJ
> Visit http://www.sql-server-performance.com for tips and articles on
> Performance topic.
>
>
> "Cqlboy" wrote:
>
|
|
|
|