Differentiate between state server session and sql server session in asp.net ?

Question

Muralidharan Deenathayalan · Answer

State server session stores all the session values into asp.net session state service. SQL Server session state stores all the session information are stored in aspnetdb database. State server This mode is best used when performance is important but you can't guarantee which server a user will request an application from. With out-of-process mode you get the performance of reading from memory and the reliability of a separate process that manages the state for all servers. SQL Server. This mode is best used when the reliability of the data is fundamental to the stability of the application as the database can be clustered for failure scenarios. The performance isn't as fast as out of process but the tradeoff is the higher level of reliability. Form more http://msdn.microsoft.com/en-us/library/ms178586.aspx