3

We had implemented web farms with SQL server session management for my asp.net applications. Some time this implementation is not working fine.

I want to know how can i check session value(exist for user) in ASPState database because i was suspected that my session are not going in ASPState database. User is getting problem in 2 out of 10 time.

Pankaj
  • 4,419
  • 16
  • 50
  • 72

1 Answers1

5

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

http://msdn.microsoft.com/en-us/library/aa478952.aspx

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

Antonio Bakula
  • 20,445
  • 6
  • 75
  • 102
  • 1
    Critical point for me was that SessionId in the table is a varchar concatenation of Asp.Net session id + ApplicationId. – Matt Evans Jan 29 '19 at 08:00