Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2007-12-12 : 05:58:18
|
| Hi,The ssis package takes 5 seconds to complete when run from the designer.This ssis package is now triggered from within a scheduled job which takes 30 seconds to complete.I do not see why there is a difference of 25 seconds.Any thoughts please?Thanks |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-12-12 : 11:33:56
|
| Does your source/destination happen to got hit by other threads harder the 2nd time?The way you monitor the time may also be a factor. Maybe the job time includes other "hand-shake" seconds in it.Finally to make it compares apple to apple, you may want to write out some of the package variables that measures the pck start time and end time to a table/log, then compare the results. |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2007-12-12 : 11:52:21
|
| Hi,I have done many checks as you mention.Job basically runs longer to complete than if starting the ssis package from the designer.Thanks |
|
|
|
|
|
|
ssis-job-speed