Post reply

How to increase the frequency of killing the inactive processes

  • October 28, 2004 at 6:47 am

    #86830

      we all know that SQL Server kills the inactive process or users  automatically/internally by background process

      I want to increase this frequency. What is the property or parameter which controls this frequency of killing the inactive process.

    or

    How to increase the frequency of killing the inactive processes ?

     

    Thanks in Advance

  • October 29, 2004 at 7:04 am

    #528389

    I don't think sql server will kill inactive process automatically...

  • October 29, 2004 at 8:41 am

    #528410

    See BOL - Orphaned Sessions - KeepAliveTime. I think this may be what you are talking about.

  • October 29, 2004 at 12:22 pm

    #528430

    it has to be, as long as the thread has a physical connection sql server will keep it open forever, you may even get warnings about threads that have been open for a very long time.

    Wes

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

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