how to simulate session end event using sql session state in server farm

Question

The session end event is not available when using SQL session state. We have an existing appication that uses this event, but we need to switch it over to SQL session state so we can set up a server farm for the application. We were hoping to use "sticky sessions" on the load balancer so we could keep using inproc session state, but were unable to get that working.

Has anyone faced a similar challenge or have any ideas?

THanks.

Answer 1

You can crate a flag on the table that stores the session state and set it to a value to indicate the session is ended.