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)
Intro to Tally Tables and Functions -
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