What is Connection Pooling

  • Hi

    We had a stop on our sql server 2008 last night,

    Please find below the information I could find.

    Message : A TCPIP socket error has occurred (10055): No buffer space is available.

    Reason : The client failed to connect to the DB2 server via a TCP/IP network, when all of the local client socket resources were in use.

    Action : Close unused client connections. Utilize client connection pooling.

    What does this mean and what steps should I take?

    Trying to catch up on this topic by google but not sure if I understand what I am reading.

    Many thanks for any response.

    Dan

  • Hi Dj

    Please research article here

    http://www.pythian.com/blog/sql-server-understanding-and-controlling-connection/

    Regards

    Mike

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

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