Post reply

Threads

  • March 10, 2008 at 9:15 am

    #69617

    I am getting so many threads in sleeping mode and Awaiting Command and its been there since Feb 28.

    Why this threads does not Release automatically or how should I diagnostic the cause of the problem.

    Any help

    Thanks

    Nita

  • March 10, 2008 at 9:32 am

    #787439

    Nita Reddy (3/10/2008)

    I am getting so many threads in sleeping mode and Awaiting Command and its been there since Feb 28.

    Why this is not getting close automatically or who do I diagnostic the cuuse of the problem.

    Any help

    Thanks

    Nita

    Nita,

    When an application opens a connection to SQL Server, once the actual work is completed, this connection will "hang around" for a default of 60 seconds before SQL Server will actually break the connection. This is to prevent the costly connection setup routine.

    Why your connections are not closing sounds like an application not closing connections properly.

    What kind of application is hiting your database? I would check all connections you refer to and see if there is a common denominator (e.g. application server).

    Thanks,

    Phillip Cox

    MCITP - DBAdmin

  • March 10, 2008 at 9:40 am

    #787446

    Thanks for your reply, this is occuring suddely it was not happen so far.

    When I do sp who2

    In Hostname I am getting sms.corp.com

    In programName I see blank

    DBName SMS

  • March 10, 2008 at 10:23 am

    #787475

    It is been called by java application and looks like the developer has open 15 pools. Now he want to leave the pool open. Is there any way I can do from SQL server to close this connection?

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

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