ASPStateTempApplications table data in ASPSTATE database

Yalla 1 Reputation point
2021-09-09T10:23:10.023+00:00

I have [ASPStateTempApplications] and [ASPStateTempSessions] tables in ASPSTATE database. I wanted to know how the data being inserted into these 2 tables. Where does AppName and AppId's are getting generated. I see some IIS worker process paths in the table for AppName. I clearly wanted to know where it is being setup and coming to [ASPStateTempApplications] table.

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,364 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Bruce (SqlWork.com) 60,871 Reputation points
    2021-09-09T18:12:19.577+00:00

    as session is tried to an IIS application, a unique key is required to define that application. IIS metadata is used. the app name is the meta base site name, and the id is a generated hex value that is appended to the a sessionid when generated.

    0 comments No comments