The scenario. We have two different servers, A and B. Server A contains a big database with lots of data. Server B is mainly used as a web server. It looks up data on server A and presents it on the web. This is mainly done via webqueryopen agents.
When I do a “show users” on server A I see a lot of live connections/sessions from server B. Why are these sessions hanging and for how long? The sessions seldom lists any open databases just that there are s session from server B. Has the number of live sessions from server B to server A something to do with the number of threads in the http task on server B?
As we have some strange problems with our servers I would just like to rule this out as a possible problem. So if anyone knows how this works I would be really greatful.
Subject: Many sessions between servers
I can’t answer most of the questions that you posted – I don’t know about the web sessions. If you want to limit how long a session exists, use:Server_Session_Timeout=xx
where xx is the number of minutes.
We use 60 on our servers. User sessions without any activity for an hour get dropped. Dropping a session does not affect users in any noticable way. If you set it too high, it will keep tons of inactive sessions open in memory for a long time. If it is set too low, the server will have to restablish sessions for users who are fairly active.
You can put the command in a configuration doc in the NAB or do it in the NOTES.INI.
Subject: RE: Many sessions between servers
Thanx. The default of 240 minutes for the Server_Session_Timoeout seems a little high so your suggestion of 60 minutes seems good.