October 28, 2004 at 6:47 am
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
I don't think sql server will kill inactive process automatically...
October 29, 2004 at 8:41 am
See BOL - Orphaned Sessions - KeepAliveTime. I think this may be what you are talking about.
October 29, 2004 at 12:22 pm
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