| Author |
server agent scheduled job - running procedure is very slow
|
|
| Michal Å trobl 2005-10-27, 7:55 am |
| Hi, I have a problem whith procedure running by server agent scheduled job.
If I initiate this procedure by Query Analyser, is running more than 100x
quicker. Procedure make loading input data from text file, about 100 000
record count and start next SQL queries.
But, I don´t know what to make for increasing performance. Like scheduled
job is this very slow...
Thanks for all ideas
| |
| Andrew J. Kelly 2005-10-27, 7:55 am |
| Do you have SET NOCOUNT ON at the beginning of the block of code in the Job?
--
Andrew J. Kelly SQL MVP
"Michal Strobl" < Michaltrobl@discussi
ons.microsoft.com> wrote in message
news:C0CAF1BE-0C85-46CB-B3EB- DCFFFB06F1D2@microso
ft.com...
> Hi, I have a problem whith procedure running by server agent scheduled
> job.
> If I initiate this procedure by Query Analyser, is running more than 100x
> quicker. Procedure make loading input data from text file, about 100 000
> record count and start next SQL queries.
>
> But, I don´t know what to make for increasing performance. Like scheduled
> job is this very slow...
>
> Thanks for all ideas
| |
| Michal Å trobl 2005-10-27, 7:55 am |
| Yes.
Andrew J. Kelly pÃ_Å¡e:
> Do you have SET NOCOUNT ON at the beginning of the block of code in the Job?
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Michal Strobl" < Michaltrobl@discussi
ons.microsoft.com> wrote in message
> news:C0CAF1BE-0C85-46CB-B3EB- DCFFFB06F1D2@microso
ft.com...
>
>
>
| |
| Michal Å trobl 2005-10-27, 7:55 am |
| Exactly, we have in job 3 steps. Each step calls own procedure. On begining
of code each procedure we call SET NOCOUNT ON.
Andrew J. Kelly pÃ_Å¡e:
> Do you have SET NOCOUNT ON at the beginning of the block of code in the Job?
>
> --
> Andrew J. Kelly SQL MVP
>
>
> "Michal Strobl" < Michaltrobl@discussi
ons.microsoft.com> wrote in message
> news:C0CAF1BE-0C85-46CB-B3EB- DCFFFB06F1D2@microso
ft.com...
>
>
>
| |
|
|
|
|