What is a SQL Server Mode of Storing Session?

[chinmay.sahoo]

• In this mode Session, state is s rializ d and stor d in a SQL Server database.

• SQL Server Session mode is more r liable and s cure session state management.

• Its keeps data in a centralized location ( atabase).

• We should use SQL server session mo e when we need to implement Session with some more security.

• If there happens to be frequent server Restart we can implement SQL server.

• This is perfect mode that fits in web farm and web garden scenarios (I have explained in details later).

• we can use SQL server Session mode when we need to share session between two different application

 

[jacks009]

I agree with this post.

 

[aditiaggarwal]

ASP.NET 2.0 allows you to store session variables at three distinct locations: In the memory of the Web server (in process) In the memory of a machine dedicated to storing session variables (state server) In an SQL Server database.

 

[luffy268]

Nice post
Keep sharing