This session mode provide us more secure and reliable Session management in asp.net. In this session mode, the Session data is serialized and stored in the SQL Server database. Main disadvantages of this session storage methods is overhead related with Data Serialization and De-Serialization. It is the best option for using in the web farms.
To setup SQL Server we need to take help of two sql Script.
- For Installing: InstallSqlState.sql
- For Un-Installing: UninstallSQLState.sql
The most easiest way to configure SQL Server, is using aspnet_regsql command.
I have explained the detailed use of these file in configuration section. This is the most useful state management in the web farm scenario.