ASP.NET Session Management Performance issue

A

Akshay Kumar

Hi All,
I was reading Perforance and Scalability Guide and reading Session State
Management section.
It says use SQL Server when using Web farm .
No where are the metrics and the Why's are msiisng.
The question that comes to mind is :-
1. When using SQL Server or State Server , will the cost of
Network Latency + Serialization + Creation of Session Objects from
Serialized data + bottleneck being 1 SQL Database (when App data resides on
Same server) not be a lot higher then using IN -Memory sessions and using
Stick IP Cookies.
There is no such explanation.
Any of you can throw some light
Regards,
Akshay
 
S

Scott Allen

Hi Aksay:

I don't think anyone can really quote hard and fast numbers to use
because it depends on the type of objects you are keeping in session
state, how frequently you access them, the number of concurrent users,
and many other factors. The only rule of thumb is that using SQL to
store session state will always be slower than keeping session state
in memory.

If your application demands the reliability provided by deploying in a
web farm scenario, than perhaps using SQL to store session state can
be viewed as an additional benefit. You'll have to do some testing and
measuring to see if the performance and throughput is acceptable for
your application.


HTH,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top