Results 1 to 2 of 2

Thread: Orphaned Connections

  1. 01-15-2002, 02:38 PM #1
    hensong Guest

    Orphaned Connections



    On SQL 6.5 we have had a couple of instances recently where an orphan connection cannot be killed and the only way to get rid of it is to stop and start the service. Does anyone know of any other way to get rid of that orphan connection?
    Reply With Quote Reply With Quote
  2. 01-16-2002, 10:56 AM #2
    derek Guest

    Orphaned Connections (reply)

    we have this issue on some servers. in the past trying to kill the sessions only suceeded in crippling SQL server until it had to be restarted, so now we leave them. if the sessions are not doing any real harm then leave them alone as SQL removes them every 2 hours (this time can be reduced to as little as you want by changing the setting in the registry - see technet for details).

    cheers

    derek


    ------------
    hensong at 1/15/2002 2:38:36 PM



    On SQL 6.5 we have had a couple of instances recently where an orphan connection cannot be killed and the only way to get rid of it is to stop and start the service. Does anyone know of any other way to get rid of that orphan connection?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules