Post reply

Slow execution using SQL Agent's job

  • April 7, 2008 at 7:46 am

    #71825

    Problem is as follows: I should to import some data from .txt files using BULK INSERT, then parse those data into proper columns in some staging table. Executing stored procedure in QA needs only few seconds to complete, but, using scheduled job to execute T-SQL having "exec procedure_name param1,param2" takes much more time to complete. I noticed that another one job executes simultaneously during my job execution, but this job doesn't affect the same objects as "my job".

    What can cause slow execution with programmed job?

  • April 7, 2008 at 3:51 pm

    #799471

    A lot of jobs can cause slowness of an SQL Server because of they may eat up most resources on this server. Once I wrote a snippet to freeze an SQL Server (not on purpose). I think I had better not describe how I did it. But it happened.

Viewing 2 posts - 1 through 1 (of 1 total)

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