I have a GP 9 environment with SQL 2005 sp3, i have an issue where on the SQL server i find myself with 4000 sessions active (the norm being 2000). I check and find that some users have multiple sessions that are from SQLs point of view "sleeping and AWAITING COMMAND". once the user loggs off however the sessions all die.
Is there a reason for all these sessions a known bug perhaps?
Does GP not have a timed inactivity logout?
GP don't have a timed inactivity logout.
and did you check what those users are doing, anything special.