January 19, 2004 at 5:16 am
Hi,
We are having a problem with server speed. On investigation, I see that there are quite a number of users who have logged on to the various apps and not logged out for up to a month, the status is AWAITING COMMAND. Does this have any effect on the server load although the app is not in use? If so is there a way of logging off a user after a defined period i.e. 24 hrs?
We are also looking at upgrading the RAM, but want to erradicate any wastage.
January 19, 2004 at 4:01 pm
It does have negative impact on server load.
You can kill aged connections by query sysprocesses, there are login_time and last_batch columns to serve your purpose.
January 20, 2004 at 9:03 am
Someone posted a useful stored procedure called usp_KillUsers a while back. I run this sp nightly from a SQL Server job to get rid of any old connections. Works well. Do a search for it on the website.
Good luck,
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply