Geek asks and answers

How to measure the duration of various tasks in a data flow task?

I am working on optimization data flow task, I thought I would see which component takes so long. I received the following tasks:

enter image description here

How do I know how much time they had? Except for time, if I can find out about other resources such as memory, CPU, etc., It will be great.

Primary I look at the time when each component took.

+5
source share
2 answers

For a quick view of elapsed time, see the Run Results tab. It will display Elapsed Time when the task / component starts and ends.

Besides

, . YMMV.

SSIS , , - :

SELECT SSIS, Logging...

. , SSIS . CSV .

: "" "OnInformation" "OnPipelineRowsSent", billinkc. , , OnPipelineRowsSent , , .

SSIS Log - For entire package

: , / , . , , , OnInformation ( OnPipelineRowsSent, billinkc).

SSIS Log - for specific component

+4

, OnPipelineRowsSent. , . sqlteam

, OnPipelineRowsSent, . , .

+2

More articles:


All Articles