SQL Server 2005 cause system to stop responding

microsoft.public.sqlserver.programming

11 Aug 2006 12:12 PM

Programatix

Hi,

I'm having problem with SQL Server 2005 (with or without SP1) on my Windows
2003 Server SP1. It causes the server to stop responding. When clients tries
to connect to it (by file sharing or print sharing), the clients will also
stop responding. If I reset the server, the clients will return to normal
after a few minutes. After a successful start up of the server, the client
will now unable to connect to any shared folder/printer provided by the
server. The users on the clients will need to log off and log in again to be
able to access the server.

Checking the Event on the server, the following error message is logged
continuously every 10 seconds,

Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17887
Date: 11/08/2006
Time: 11:14:11 AM
User: N/A
Computer: CATALYST
Description:
IO Completion Listener (0xa64) Worker 0x008880E8 appears to be non-yielding
on Node 0. Approx CPU Used: kernel 0 ms, user 0 ms, Interval: 2498125.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: df 45 00 00 0a 00 00 00   ßE......
0008: 09 00 00 00 43 00 41 00   ....C.A.
0010: 54 00 41 00 4c 00 59 00   T.A.L.Y.
0018: 53 00 54 00 00 00 00 00   S.T.....
0020: 00 00                     ..

Any help would be greatly appreciated. Thanks in advance.