How to check session value (exists for user) in ASPState database using SQL Server Session Management

We used SQL Server Session Management web farms for my applications. This implementation doesn't work fine for a while.

I want to know how I can check the session value (exists for the user) in the ASPState database because I suspected that my session is not in the ASPState database. The user gets problems 2 out of 10 times.


source to share

1 answer

Look at the ASPStateTempSessions table in your SQL Server Sessions database and find your value by SessionId. To be more precise, the SessionId in the ASPStateTempSessions table is a sequential concatenation of the Asp.Net session ID + ApplicationId. You can find out more on this page:

(Updated with Matthew's comment: ASPStateTempSessions.SessionId = ASP.NET SessionId + ApplicationId)



All Articles