hello,
We have an application that is developed in MS Access. I have seen instances where even though user has opened the application but not doing any work, it will still show me a "suspended" session at the database level and these sessions will remain like that for a long time like 2-3 hours. When i checked with users they are not doing any activity. my question is do these suspended sessions consume resources like IO/CPU/memory? other thing is why is sp_who2 'active' show me these sessions when they are suspended for a long time and they are not actually active. How do i eliminate them?