Question about SQLServer Session State Management

  • Thread starter Thread starter gnewsgroup
  • Start date Start date
G

gnewsgroup

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.
 
Your session objects are indeed stored in the database. They are in binary
serialized form, that's why you cannot "see" what you are looking for.
--Peter
 
Your session objects are indeed stored in the database. They are in binary
serialized form, that's why you cannot "see" what you are looking for.
--Peter
Click to expand...

In the SessionItemLong field?

So,

1. Each session will have only one row in the database?

2. Every time when a session object is created fresh or updated, the
SessionItemLong field is updated?

Thank you.
 
Back
Top