Wait_type= Sleep

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Wait_type= Sleep_Task?

Wait_type= Sleep_Task?

Rate Topic

Display Mode

Topic Options

Author

Message

M@hesh

Posted Sunday, January 13, 2013 10:58 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:01 AM
Points: 10, Visits: 253

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

Post #1406574

Bhuvnesh

Posted Monday, January 14, 2013 3:07 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1406626

« Prev Topic | Next Topic »

Permissions