Post reply

100+ Queues/Jobs calling one Procedure

  • January 8, 2018 at 2:52 am

    #327120

    Hi Experts,

    i have created 100+ Jobs which is calling one procedure which is effecting the speed, any other better option for speeding up the process,
    For Example:-

    if i call the procedure normally which is taking one second to process, because of the 100+ jobs the processing time goes upto 3-30 Seconds,

    Please suggest some better Idea.

    Thank you
    Mohamad Feroz Patel

    Patel Mohamad

  • January 8, 2018 at 5:21 am

    #1974878

    Sounds like you need to tune the query. If lots of processes have to call the same query, you need that query to run fast in order to support lots of processes.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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