how to kill database connection-emergency

  • Hi everyone,

    Our sql server just doesn't take any connection.

    Even I restart our server and sql server database, which is on the same computer, cpu drops to normal. But as soon as I try to any program, the cpu will rise to 100%. Or you will get an error message:

    Description: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Invalid connection

    or

    Description: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

    Then the tech support told, that windows just won't drop all the connection, that's why I cannot connect to the database

    So we use netstat cmd and I see more than 1000 line of this

    TCP    travelinsure1:3838     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3840     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3842     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3844     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3846     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3848     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3850     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3852     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    TCP    travelinsure1:3854     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    Is this the problem origination? if so, how can I kill the connection immediately?

     

    Thank you.

    BEtty

  • when u stop and start SQL server all the connections would have been lost or killed. How can a tech support tell u that "Old" connection still exists.

    Try running:

    sp_who and look for blocks(More Info on BooksOnline)

    then look as sp_lock

    That will be a good starting point.

    Thanks

    Sreejith

  • <Server does not exist or access denied>

    can you access the sql serve (let say from Query Analyzer)?

    Also what is OS\Edition\version\SP\ security patch level(fresh or a lot missed)

    same for sql server: version\edition\SP?

     

  • No, not even from sql server analyzer, it just refuse any connection from any where. But if I get into enterprise manager, -->tool, -->sql ananlyer, the query can be run slowly.

    Our system is windows 2000 server 5.00.2195 service pack 4,

    sql server is 2000 with sp4 just applied one week ago.

  • Hi Sireejith,

    Exactly, that' what exactly I asked. I used sp_who and sp_lock,

    it is quite normal, we just have several connection to production database. and in enterprise manager,-->current activity--> I don't many processes.

    But when I use this command netstat I see many active connection with different port number and I cannot explain it.

    Betty

  • Hi everyone,

    Can you give a hint. If I ran netstat and I have thousands active connection like this:

    TCP    travelinsure1:3838     travelinsure1.inetu.net:ms-sql-s  TIME_WAIT

    but travelinsure1 is our web server and our database server is on the web server too. It seems like the web server itself is trying to connect to our database server. Like infinit loop, since local address is travelinsure1 and remote address is  travelinsure1.inetu.net:ms-sql-s.

    Am I right, it looks like a infinite loop.

    Betty

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

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