Session State Performance Metrics

[Guest]

What kind of performance hit (typically, in terms of percentages) can we
expect when we use SQLServer instead of InProc or StateServer mode for
maintaining the session?

Thanks.

 

[Karl Seguin]

Simple google search returned this:

http://www.eggheadcafe.com/articles/20021016.asp

which suggests a 15% slowdown for StateServer and 25% for SQLServer (I would
have expected those two to be closer)

you probably want to take a look at
http://oraasp.vicp.net/doc/doc.aspx?ID=2 also

but without know what kinda data (and how much) you'll be storing, it's all
theoretical....only your own testing will be able to uncover the true data.

Karl

 

[Saravana]

It depends upon what you are going to store in sessions. It will vary
depending upon number of objects, you are going to store it in sessions. Its
better to do the performance testing for your own scenario