Latest:
Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2017
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up What are the Advantages of SQL Server mode Session?

    1. Session data do not affected if we restart the IIS.
    2. It is the most reliable and secure session management.
    3. It keeps data located centrally, It can be easily accessible from other application.
    4. It is very useful in web farm and web garden scenarios

  2. #2
    Join Date
    Apr 2014
    Posts
    183
    Thanks
    0
    Thanked 9 Times in 9 Posts
    Advantages:

    1. If IIS restart session data not affected /application not affected with inProc session we face this issue frequently.
    2. More Secure and reliable compared with InProc and state server.
    3. Usefull in Web farm and Web gardens scenarios.

  3. #3
    Join Date
    Apr 2014
    Posts
    183
    Thanks
    0
    Thanked 9 Times in 9 Posts
    If you have that kind of presence, you are bound to gain aggregate value for your organic listings because, if you are marketing well, your traffic will go up, click-through rate will go up and your conversion rate will go up. I firmly believe that if you are improving those things, your rankings will improve also.

  4. #4
    Join Date
    Apr 2016
    Posts
    100
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I don,t think it,s a advantage to use SQL server mode session as every-time external configuration required for sql server session state.

  5. #5
    Join Date
    Mar 2017
    Location
    Bangalore
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts
    - Sessions are very simple to use. If you have a global variable related to individual visitor, you can place it in session and it will be visible from all pages on website.
    - If InProc mode is used, any type of object could be stored. In case that Session State or SQL Server is used, objects must be serialized before saving.
    - Separated global data for each visitor. Every visitor has its own collection of session variables.

  6. #6
    Join Date
    Mar 2017
    Posts
    29
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sql server session is slow, has object serialization requirements, but can be shared between several web servers.

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Earn Reward Points ($$$)

Join our network and earn points through contribution, engagement, reference and doing promotional activities. How to earn more?

Start Here to Contribute

How to Cash Out?

Check Winners of the Week !!

Earn upto 150 points as startup bonus
Not a member Yet? Join Now and start earning.

Recommended Sections to Visit: Articles Resources Directory Catalog Add Your Site