For asp.net web application, I had thought that using SQL Server
Session State management would imply that all session objects be
stored in SQL Server database ASPState.
But when I look into it, I notice that only stuffs related to
SessionID are stored in the database. None of my session objects such
as Session.Contents["UserName"],
Session.Contents["MyCustomerDataTable"] can be found in the database.
So, is it the case that session objects are really stored in memory
just like InProc session state mode? Thank you.