What is SQL state database? Why do we need it?

Answer

ASP.NET session state provides several different options for storing and managing session data:

InProc mode (Default) Stores session state in memory

StateServer mode Stores session state in a separate process called the ASP.NET state service.

SQLServer mode Stores session state in a SQL Server DB.

Custom mode Stored state in custom provider.


SQL state database is a database which used in SQLSever mode.

We need it to enable webfarm scenarios there multiple machines should be able to share session data.






Answers and Comments