Is more fater the execution of a store procedure?

  • Hi friends, how are you?, well here in my work, my partners with me we were executing store procedures , well we found that the store procedures that they were executed into a DTS and they were faster than those were executed by job only, is true that? is the perfomance of an execution of a sp into DTS better that it will be execute into a job? thanks for your comments, sorry my bad english

  • Dunno, Hector... I hardly ever use DTS so I've never made the comparison.  Seems like you have, though.  I do have a couple of DTS jobs coming up in the future... I'll let you know after I test them.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • I don't know about faster.  While I haven't done any clocking, I have used DTS extensively and haven't really noticed that.

    I do know that most prefer to avoid DTS in 2000 because it has rather poor logging / error handling.

  • I can't answer your question, but I have noticed that identical queries run from QA and

    from an application can take radically different time. My conclusion when I ran across this was that the two queries, for some reason, must use different execution plans.

    /HL 

  • Counting time is not a easy issue... specially in the network.

    Many parameters must be taken into account...

    I really have a lot of questions before i get into final result.

    1.Actually, what do u mean... "faster"? In seconds, minutes?

    What is the difference in time between two?

    2.Did u disable the cashing before run?

    i.e. :

    DBCC FREEPROCCACHE on

    DBCC DROPCLEANBUFFERS on

    CHECKPOINT

    SET STATISTICS IO on

    SET STATISTICS TIME on

    SET STATISTICS PROFILE on

    SET SHOWPLAN_ALL

    3.How many runs did you performed and which method you use to compare the results (i.e. taking the average)?

    4.Did u check the network trafic? How many users hit the server?

    5.Did u execute in a server as a client?

    ------------
    When you 've got a hammer, everything starts to look like a nail...

  • MMMM perhaps i didnt let free the cache, mmm but i wanted to know if for some reason the executions into dts is faster, well i thought that dts have used some dedicated conections but i couldnt find some information about that.. thanks i will do some tests and then i will tell you, thanks everybody

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

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