Post reply

Orphaned sessions in SQL Server

  • January 20, 2003 at 12:08 pm

    #159117

    I have a group of developers who created an app with Excel. they pull data into a spreasdsheet, take it offline, manipulate data, then sync back up. the question came up of what happens during a re-sync of data if the client connection is lost? (say they are connected via a RAS dial-up and lose thier dial-up). The problem is any locks are held for the orphaned connection until the spid is killed by an admin or the TCP/IP connection times out (1 - 2 hours!)

    Can anyone tell me the best practice here? Or how to handle the orphaned connections?

    Thanks.

  • January 23, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • October 11, 2005 at 11:45 am

    #596603

    Hi Newbie,

    I would like to know few information before giving you the solution.

    Is the server has any other applications accessing the database.

    If yes then you can write a query to check for orphaned connections on the server and delete them.

    However you can just manually check the database for any orphaned sessions and then delete them.

    We will consider the processes of 30 min as last batch as orphaned.but it depeneds on the application on how much time can you consider a connection as orphan

     

     

     

     

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

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