|
|
Posted by Simon Hayes on 09/07/05 13:25
I have no real idea, but perhaps if you give some more information
someone will be able to suggest something - are you executing exactly
the same command in the job, or are you using different parameters in
QA, for example? When you say that Profiler shows the proc "twiddling
its thumbs", what does that actually mean - what event types are you
seeing? Is the proc doing something unusual, such as a BULK INSERT, or
just modifying data? Are any other jobs or processes running on the
server at the same time? Etc.
Simon
Navigation:
[Reply to this message]
|