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.
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.