July 11, 2002 at 10:04 am
This is a 6.5 issue but could be common in all version.
Is there a way to automatically kill inactive processes? We have about 15 users constantly querying the database over the web. In addition there are loads running all the time and other reports. These processes quickly pile up (even thoguh most of them are sleeping) and we reach the max processes reached. Bumping the max number is not the solution. Is there a way to auto kill these web processes after being inactive for one minute (the host name is in the sysprocess table). many a times we have to re-cycle SQL Server as the only way out since some of the processes show a 'spinloop' status which I believe is a resource lock.
Any help will be appreciated.
Regards,
Naushi Hussain
Regards,
Naushi Hussain
July 11, 2002 at 10:49 am
No way I know of. I wrote a script that would check the last batch time and use exec() to kill the spid.
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply