SQL Server 2005 Sleep Type: Sleep_Task

Question

Recently I came across a type of expectation about which I cannot find much information. I have a stored procedure that takes about 1.0 hours, but when the connection on the activity monitor displays the Sleep_Task wait type, SP can work for several days if I did not kill it. He just sits there, doing nothing.

Does anyone have any information on what this type of expectation is and why this is happening?

Thanks,

Chris dba

Answer 1

Hmm, I thought it was a dead end, but BOL says:

Sleep_Task Occurs when a task is executed, waiting for a general event to occur.

Someone on SqlServerCentral messages:

processID, .

?

, pre-SP2 SqlServer2005:

http://social.msdn.microsoft.com/Forums/en-US/sqlnetfx/thread/942fe3d4-141a-486a-afdf-53f079d3a4d3