5 Replies Latest reply on Feb 24, 2015 6:58 PM by jaminsql

    execution time for a query

    anncao

      I am using DPA for SQL server. It shows a query that is top expensive query. I located the query which is an nightly SSIS package uses a data flow task to import data from a table to another database table.

      The query result set is very big. But it should only run one time in the data flow task.


      But I see in DPA execute time is 4 times. I cannot figure out why it shows 4 times .

       

      Any ideas?

       

      Thanks