January 13, 2013 at 10:58 pm
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
January 14, 2013 at 3:07 am
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;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply