Post reply

Server TCP provider has stopped

  • April 26, 2011 at 8:32 am

    #239005

    Hi all,

    SQL server 2005 with 4G RAM is getting error below

    Server TCP provider has stopped listening on port [ 1433] due to a failure. Error: 0x2747, state: 1. The server will automatically attempt to reestablish listening.

    Server TCP provider has successfully reestablished listening on port [ 1433 ].

    what could be the reason.

    Regards,
    MShenel

  • April 26, 2011 at 7:40 pm

    #1316344

    The full error message is "An operation on a socket could not be performed because the system lacked sufficient buffer space or because a queue was full."

    Are there any other applications running on SQL Server? If yes, minimum SQl Server memory probably needs to be increased.

    Also, check if you have any resource intensive tasks that run (scheduled) at the time of the error.

  • April 27, 2011 at 8:26 am

    #1316630

    This seems indicative of an underpowered server. Not enough hardware or potentially a driver issue.

    Is this replication, as in this one? http://stackoverflow.com/questions/1110981/unknown-performance-issue

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply