I haven't seen the
SLEEP_TASK wait type before, and today I seem to be getting a ton of them.
I'm not the official DBA, just a SQL Server developer who knows some DBA stuff. We upgraded our servers last weekend to
10.52.2500.0 - R2SP1 I think.
All the info I could find online indicates that
SLEEP_TASK means the server is waiting on some sort of internal process to complete. I don't have any blocking or any background processes like checkpoints or ghost cleanup running, so I'm a bit stumped.
Has anyone seen this wait type before, and if so can you give me an idea of what is causing it?