Always use dtexec.exe to test performance of your dataflows. No exceptions.

Posted by jamiet on SQL Blog See other posts from SQL Blog or by jamiet
Published on Wed, 12 Jan 2011 21:51:21 GMT Indexed on 2011/01/12 22:57 UTC
Read the original article Hit count: 216

Earlier this evening I posted a blog post entitled Investigation: Can different combinations of components effect Dataflow performance? where I compared the performance of three different dataflows all working to the same overall goal. I wanted to make one last point related to the results but I thought it warranted a blog post all of its own.

Here is a screenshot of one of the dataflows that I was testing:

image

Pretty complicated I’m sure you’ll agree. Now, when I executed this dataflow in the test it was executing in ~19seconds however in that case I was executing using the command-line tool dtexec. I also tried executing inside the BIDS development environment and in that case it took much longer – 139seconds. That’s more than seven times as long.

The point I want to make is very simple. If you are testing your dataflows for performance please use dtexec. Nothing else will suffice.

@Jamiet

© SQL Blog or respective owner

Related posts about dataflow

Related posts about dtexec