Post reply

Want to close the inactive connections in sleeping mode (SE)

  • April 3, 2009 at 12:50 am

    #100611

    Hello,

    Can any one help me how to close the inactive(sleeping) connections in sql server 2000.

    I checked in using sp_who2,

    so many connections are not closing while its in sleeping mode. We are using VB.net Application, even we tried to close in application also.

    Awaiting for reply asap.

  • April 3, 2009 at 2:23 am

    #971346

    Hi,

    The connections don't 'close' in sleeping mode- you would need to 'kill' them.

    You could kill all the processes that aren't system processes, but why do you want to 'close' them?

  • April 3, 2009 at 2:54 am

    #971360

    Sleeping just means not currently running queries. While you can kill them, doing so may well cause problems for the applications if the assume that the connection will remain open.

    Why do you want to kill them?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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