I'm curious to your experiences with performance gains/losses with the different types of session state management (InProc, StateServer, SQLServer).
InProc is pretty much unusable in our projects due to building/deploying issues, so I have the choice: aspnet_state.exe or SQL Server? Probably both have their pros and cons, but which one do you think is 'best'?
Links to webpages/articles are of course very welcome, too.
Thanks,
Michel
-
-
I'm still trying to figure out why my app occasionally loses the Session vars altogether. It's like the process restarts, but it doesn't show in the event log as having restarted. It's more like the session state just resets and I lose all my values. I'm sure it will take a lot of man hours to find.
-
in reply to LazyCoder, everytime you change the global.asax, web.config, or dll files, it will cause you app to reset.. ALSO, you can go to the properties of the Application Bag for which your asp.net app is attached to, and look at the worker thread config. something may have been changed?
in reply to miies
aspnet_state.exe or SQL Server...
with SQL Server, your session can persist permanently and is most secure, yet it requires an SQL transaction during session state management, something that can become quite costly..
Im not too sure about the session server (out-of-proc).. but I usually only hear people using inproc or sql
THIS forum at ASP.net Forums is GREAT .. they answer quite quickly and there is TONS of information to go through.
http://www.asp.net/Forums/ShowForum.aspx?tabindex=1&ForumID=22
Jake -
Thanks. I've found some hard figures (more or less) in this, very informative, article by Dino Esposito:
http://www.vsj.co.uk/articles/display.asp?id=286
StateServer: approx. 15% overhead
SQL Server: approx. 25% overhead
Thread Closed
This thread is kinda stale and has been closed but if you'd like to continue the conversation, please create a new thread in our Forums,
or Contact Us and let us know.