Post reply

Packages very slow to Start

  • April 20, 2010 at 4:16 am

    #231873

    I am wondering if there is a way to stop package validation effectively? (Am I asking too many questions?)

    When I open the package, or when it is run as a scheduled task via SQL Server Agent the validation it takes a long time to start working. Also I have one package that calls another, and this causes quite a pause inthe overall process.

    I realise that there is a very good reason for the pre-validation, but I'd like to disable it if possible for these two particalar packages.

    Is there some way to do this to the package as a whole?

    Thanks,

    Paul

  • April 20, 2010 at 6:22 am

    #1154494

    In the package properties, under Execution, set DelayValidation to True.

    I'm not sure how much time this will save, so just try it out and let us know 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 20, 2010 at 6:44 am

    #1154510

    Thanks very much! My package now executes immediately, rather than pausing before it starts. There is still a minor 10 second pause between packages, but this is much improved on the 60 second previous.

    Great advice.

    😀

  • April 20, 2010 at 6:59 am

    #1154527

    Paul_Harvey (4/20/2010)

    Thanks very much! My package now executes immediately, rather than pausing before it starts. There is still a minor 10 second pause between packages, but this is much improved on the 60 second previous.

    Great advice.

    😀

    Glad to help. These 10 seconds will never get away I think, as SSIS still needs time to read the .dtsx file, possible configuration files/tables and interprete all this stuff.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 20, 2010 at 7:04 am

    #1154533

    No complaints at all.

    10 seconds is perfect. To be honest there was also quite a significat delay before execution of th efirst package, and this has completely gone.

    So far today I have tuned my package down to 25% of the original running time.

    Its been a productive day performance-wise.

    This was a big help as part of that.

    Thanks again.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply