Question about SQLServer Session State Management

[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.Content s["UserName"],
Session.Content s["MyCustomerData Table"] 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.

[Peter Bromberg [C# MVP]]

Re: Question about SQLServer Session State Management

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
"gnewsgroup " <gnewsgroup@gma il.comwrote in message
news:504f9c56-98f7-4b91-a847-9f2570bacfab@s5 0g2000hsb.googl egroups.com...

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.Content s["UserName"],
Session.Content s["MyCustomerData Table"] 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.

[gnewsgroup]

Re: Question about SQLServer Session State Management

On Apr 29, 2:49 pm, "Peter Bromberg [C# MVP]"
<pbromb...@nosp ammin.yahoo.com wrote:

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

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.