Three Modes of Session State Is available In Asp.net
InProc Mode - The session State is stored In the Memory of the local where ASPnet_Wp.exe Process is runnning.When we Restart the application or reboot the IIS , the session state is lost
State Server or OutProc - The session state is serialized and stored in a Seperate Process (ASPnet_state.exe).It can be stored on a Seperate system If needed.
SQL Server - The session State is Serialized and Stored in the Sql server Database.