I am getting this alert regularly in our environment. Does anyone have any clue about it:
IO Completion Listener (0x110c) Worker 0x00D0E0E8 appears to be non-yielding on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 35000.
What is the impact of this alert and how can it be controlled? I am running SQL 2005 SP1.
Thank You.