Post reply

Performance Problem

  • July 16, 2002 at 8:24 am

    #101197

    Hi everybody!

    I have here a performance issue. If I run the SP in Query Analyzer it takes like almost 2 minutes. (I think is normal. The SP is using cursors and does a lot of calculations)

    But if I run the same SP in a job it takes almost 6 minutes. And I run them on the SQL Server, so there is no network traffic or something else. Just to mention that the job has 3 steps (one of them is the SP. The Step with the SP is running for 6 minutes)

    Does anybody know if this is how is supoosed to be, or I'm missing something?

    Thanks

    durug

  • July 16, 2002 at 11:26 am

    #432818

    I have found through testing that processes executed by SQL Agent tend to run slower than executed manually. One work around is to have the job step execute a command line osql or isql command with the query. This is how we're doing some of our large mainframe extract imports.

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • July 16, 2002 at 1:39 pm

    #432822

    Thank's a lot.

Viewing 3 posts - 1 through 2 (of 2 total)

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