Wait_type= Sleep_Task?

• M@hesh

  Old Hand

  Points: 375

  More actions

  January 13, 2013 at 10:58 pm

  #287724

  Hi,

  Job is taking much time to execute, when i check the Wait type it shows 'Sleep_Task' and there is no blocking in the server.

  could you please provide the sleep_task trouble shooting steps

  Thanks in Advance

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  January 14, 2013 at 3:07 am

  #1576808

  M@hesh (1/13/2013)

  ---

  Job is taking much time to execute, when i check the Wait type it shows 'Sleep_Task' and there is no blocking in the server.

  it can, but for better help you need to tell following things.

  1) why/how do you think it is taking longer time ? how much time does it take regularly.

  2) it is frequantly or randomly ? or at any specfic time ?

  3) what does it contain ? Stored proc / query ? if yes have you look into it ?

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)