show dts

Shows the data transfer stream (DTS) information that is running on a DA agent.

Syntax

show dts

Examples

Example 1 – shows all the DTS information for a DA agent:

show dts
go

The returned result is:

TASK ID ESTIMATE COUNT FETCHING  QUEUE TAKEN ESTIMATE SECONDS LEFT
------- -------------- --------  ----- ----- ---------------------
3       1000                     0     0