Post reply

How to RELEASE connections in SQL Server 2000

  • September 6, 2007 at 9:27 am

    #125456

    In evaluating the performance of my SQL Server, I discovered over 100 connections, most of which show a status of SLEEPING. Quite a number of those appear to be un-released connections from some time ago. How can I release them from Query Analyzer or Enterprise Manager?

    Thanks in advance for your help!

    Austin

  • September 6, 2007 at 10:13 am

    #731912

    kill spid

     

  • September 6, 2007 at 10:48 am

    #731923

    Thank you, Mark, for the response to my question. I am unsure, though, how or where to run KILL SPID. Can you further point me in the right direction.

    THANKS again.

    Austin

  • September 7, 2007 at 6:33 am

    #732108

    The connections are not active and, therefor, nothing you really need to worry about.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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