Home Forums SQL Server 2005 Administering Communications to SQL server "freeze", then resume. RE: Communications to SQL server "freeze", then resume.

  • Not every time but a couple times this morning I have captured a small group (10-15) of ATTENTION events in Profiler AFTER these freezes are over. I very seldom otherwise see the attention event and it's coming from IIS so I figure those are timeouts from someone running a report. But when the freeze happens and ends, a few of the events are dumped in all at once, sometimes.

    Saw this:

    "The Attention event class indicates that an attention event, such as cancel, client-interrupt requests, or broken client connections, has occurred. Cancel operations can also be seen as part of implementing data access driver time-outs"

    Also, one time of all the time during locking I got an error message from a user (this error has only ever been seen once during all the blocks):

    "Error: [DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.

    Called: frmMain:SearchTran"

    We get this kind of error some times when our switch reboots. That error was only seen once though of all the countless freezing times.