ASP.NET Session Management Performance issue

Discussion in 'ASP .Net' started by Akshay Kumar, Jul 2, 2004.

  1. Akshay Kumar

    Akshay Kumar Guest

    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
    Akshay Kumar, Jul 2, 2004
    #1
    1. Advertising

  2. Akshay Kumar

    Scott Allen Guest

    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,

    --
    Scott
    http://www.OdeToCode.com

    On Fri, 2 Jul 2004 13:21:42 -0400, "Akshay Kumar"
    <> wrote:

    >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
    >
    Scott Allen, Jul 2, 2004
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jeff Smythe
    Replies:
    3
    Views:
    1,240
    Jeff Smythe
    Jan 2, 2004
  2. =?Utf-8?B?ZGFtb24uZg==?=

    Exception Management AB Issue in ASP.NET

    =?Utf-8?B?ZGFtb24uZg==?=, Jan 22, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    445
    =?Utf-8?B?ZGFtb24uZg==?=
    Jan 22, 2004
  3. Floris van Haaster

    Project management / bug management

    Floris van Haaster, Sep 23, 2005, in forum: ASP .Net
    Replies:
    3
    Views:
    1,239
    Jon Paal
    Sep 23, 2005
  4. pouet
    Replies:
    2
    Views:
    753
    Will Hartung
    Jul 30, 2004
  5. Abubakar
    Replies:
    0
    Views:
    371
    Abubakar
    Aug 31, 2008
Loading...

Share This Page