Is more fater the execution of a store procedure?

Question

Is more fater the execution of a store procedure?

Hector Angello Silva Carmona

SSCrazy

Points: 2720
More actions
April 24, 2006 at 3:16 pm

#112592

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

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

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

Jeff Moden SSC Guru Points: 1004410 More actions · Answer 1

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)

Pam Brisjar SSChampion Points: 12094 More actions · Answer 2

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.

Henrik Litsne SSC-Addicted Points: 466 More actions · Answer 3

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

Andreas AJV SSC Eights! Points: 800 More actions · Answer 4

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...

Hector Angello Silva Carmona SSCrazy Points: 2720 More actions · Answer 5

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