Just wrote a new article on CodeProject with information on how to manage sessions ending when using a StateServer other than InProc, which don’t fire the Session_End event.

Check it out:
ASP.NET HttpModule for handling session end with StateServer